We discovered ( and reported via email in September 2020) that ag-grid automatically adds an hour to 2:00-2:59 datetime values on daylight savings start dates—for example:
So, if we import a file with the datetime 3/8/2020 2:00, ag-grid displays and saves to database as 3/8/2020 3:00. This results in TWO hourly measurements for 3:00. It would be great if this quirk could be addressed in future versions of CDMS.
We discovered ( and reported via email in September 2020) that ag-grid automatically adds an hour to 2:00-2:59 datetime values on daylight savings start dates—for example:
'3/13/2016' ,'3/12/2017' ,'3/11/2018' ,'3/10/2019' ,'3/8/2020'
So, if we import a file with the datetime 3/8/2020 2:00, ag-grid displays and saves to database as 3/8/2020 3:00. This results in TWO hourly measurements for 3:00. It would be great if this quirk could be addressed in future versions of CDMS.