Forum Discussion

kirbynguyen's avatar
kirbynguyen
Helper II
2 years ago

Generated Datetime table

I am creating a datetime table with a row for every 5 minutes. Here is my code:

 

DateTime =
GENERATESERIES (
DATEVALUE ( MIN ( Table[Date] ) ),
DATEVALUE ( MAX ( Table[Date] ) ),
TIME ( 0, 5, 0 )
)

 

The values for Table[Date] actually don't matter and can be hard coded, so no actual data is needed to create this. For some reason, though, the datetime table works for about 20 days and then is off by one second. Instead of 1/21/2022 5:10:00 PM, it shows 1/21/2022 5:09:59 PM, and then every data point after that is off by one second (everything ends with 59 instead of 00.

 

 

Why is this happening and how do I fix it?