Why DateTime not updating properly when changing the dateTime with format "t"

Reported by Mohanraj Gunasekaran Sep 12 at 07:13 AM .net c#

I have used DateTime column in datagridview and DateTime format is "t".

Code

this.dataGridView1.Columns["Date"].DefaultCellStyle.Format="t";

I have tried to change the date time value then call EndEdit metod in CellValidating event. Now, i got the current date value. Let me know the reason for this.

Code

this.dataGridView1.CellValidating+=DataGridView1_CellValidating;privatevoidDataGridView1_CellValidating(object sender,DataGridViewCellValidatingEventArgs e){if(this.dataGridView1.CurrentCell.IsInEditMode){var value1 =this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;this.dataGridView1.CellValidating-=DataGridView1_CellValidating;this.dataGridView1.EndEdit();var value2 =this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;}}

Screenshot

Sample link: https://drive.google.com/open?id=1irz7mZm1n-dRfiCvttaaNdxpbkQkIjvU

Thanks,

Add comment Show 6

John Qiao (Beyondsoft Corporation) · Sep 17 at 05:59 AM 1

Thank you for your feedback!

For us to investigate this further, could you please provide the expected value of your value2? From the screenshot we can see the value2 has changed, if it's not the expected value, which value is expected in your values or DataGridView cell?

To display the date and time value in DataGridView, we could use below DateTime format:

this.dataGridView1.Columns["Date"].DefaultCellStyle.Format = "MM/dd/yyyy hh:mm:ss tt";

We look forward to hearing from you!

Mohanraj Gunasekaran John Qiao (Beyondsoft Corporation) · Sep 17 at 06:09 AM 0

Thanks for your update @John Qiao (Beyondsoft Corporation),

My dateTime format is "t". So, i can change the time only in UI and modified the time from 12:00 to 10:00. not modify the date value.

My expected value is "5/23/2012 10:00:00 AM" in value2.

John Qiao (Beyondsoft Corporation) · Sep 17 at 07:19 AM 0

Thank you for your feedback!

We have determined that this issue is not a bug.

Please use follow code to set the DateTime format:

this.dataGridView1.Columns["Date"].DefaultCellStyle.Format = "MM/dd/yyyy hh:mm:ss tt";

Mohanraj Gunasekaran John Qiao (Beyondsoft Corporation) · Sep 19 at 04:15 AM 0

I know how to set the format for datetime column. I want to show the time only for DateTime column so i have set the format as "t". Please try to understand my query. If i use the format as "t" for datetime column and try to edit that time value in DateTime column which will be changed automatically to current date and it has already shown in above screenshot. I want the reason for this.I hope you have understood my query.

John Qiao (Beyondsoft Corporation) Mohanraj Gunasekaran · 12 hours ago 0

Thank you for your reply!

We have determined that this issue is not a bug. Please try to use that solution which Klaus provided us!

John Heckendorf John Qiao (Beyondsoft Corporation) · Oct 04 at 06:42 AM 0

The issue seems to be that if the Format is "Time" (eg. hh:mm:ss) and a user changes the Value of a Field containing "(2018-09-09) 20:10:00" to 10:00:00, it discards the Date information and uses the Current date for the new Time value

2018-09-09 20:10:00 becomes 2018-10-04 10:00:00 after you change the Time part (20:10:00 -> 10:00:00) in the UI/Grid

Added a solution by Klaus Loeffelmann [MSFT] · Oct 08 at 12:18 PM

Everything we see here is By Design.

But the solution is easy: The time is separated from the date part, and we need to add the missing date part in the parsing, so the easiest way to this end, is to introduce a custom parse mechanism which would be looking like this:

private void dataGridView1_CellParsing(object sender, DataGridViewCellParsingEventArgs e)  
{
   if (e.ColumnIndex == dataGridView1.Columns["Date"].Index)  
   {
      e.Value = DateTime.Parse(DateTime.Now.ToShortDateString() + " " + e.Value);  
      e.ParsingApplied = true;  
   }  
}

As a tip for this scenario: We should be aware here of the date change threshold, though, since the date part is NOT explicitly to enter in this scenario. So, for example entered time parts in the DataGridView with a value < 4:00 AM should not be added to the Today date (Now), but rather to Now.AddDays(1), since it very likely that the particular point in time might be after midnight: the "booking date" would be today, but the actual date would not be today in the morning, but rather at the end of the day which has been passed midnight (tomorrow). To have a booking date in such scenarios which reflects the assignment time is therefore often a good idea. HTH Klaus

Add comment · Share

Developer Community

Get help from our community supported forum

Why DateTime not updating properly when changing the dateTime with format "t"

Solutions

Try Microsoft Edge

Developer Community

Get help from our community supported forum

Why DateTime not updating properly when changing the dateTime with format "t"

Solutions

Related Problems