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

.net c#

Mohanraj Gunasekaran reported Sep 12, 2018 at 07:13 AM

Add comment Show 6

Add Comment

John Qiao [MSFT] · Sep 17, 2018 at 05:59 AM 1

Mohanraj Gunasekaran John Qiao [MSFT] · Sep 17, 2018 at 06:09 AM 0

John Qiao [MSFT] · Sep 17, 2018 at 07:19 AM 0

Mohanraj Gunasekaran John Qiao [MSFT] · Sep 19, 2018 at 04:15 AM 0

John Qiao [MSFT] Mohanraj Gunasekaran · Oct 15, 2018 at 07:12 AM 0

John Heckendorf John Qiao [MSFT] · Oct 04, 2018 at 06:42 AM 0

Solution by Klaus Loeffelmann [MSFT] · Oct 08, 2018 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, 2018 at 09:15 AM 0

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

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