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

.net c#

Mohanraj Gunasekaran reported Sep 12 at 07:13 AM

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

Add Comment

John Qiao [MSFT] · 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 [MSFT] · 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 [MSFT] · 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 [MSFT] · 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 [MSFT] Mohanraj Gunasekaran · Oct 15 at 07:12 AM 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 [MSFT] · 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

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 Show 2 · Share

Add Comment

Mohanraj Gunasekaran · Nov 01 at 09:15 AM 0

Thank you @Klaus Loeffelmann [MSFT]

Actually, i have tried to store the values in my db when i make the changes in date cell without date format. So, if i set the format for date column and i edit that cell i am always getting today's date. So, my db date values are stored with current date. How can i overcome this? Am i need to replace today's date by old date?

Klaus Loeffelmann [MSFT] Mohanraj Gunasekaran · Nov 01 at 09:21 AM 0

It's hard to tell for me, since I don't know your business case, so I can only try to give you advise in principle. If I understood the scenario correctly, I would separate the original date, let the user edit the time part, and then restore the old date+the new time part. So, if I understood correctly what you said, that sounds reasonable. Hope that helps!

Developer Community

Get help from our community supported forum

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

Add Comment

Solutions

Add Comment

Developer Community

Get help from our community supported forum

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

Add Comment

Solutions

Add Comment

Related Problems