Numeric Representation Of Dates And Times

[Community_Admin]

Question

I have to do a MAX(<ColumnName><of DateTimeFormat>) in the dashboard.

The main thing here is that I have to have the last second entry for that specific field.

Answer

We suggest you would use a float numeric representation of the date, adding the minutes and seconds AFTER the dot.

For instance, the date "4/21/20 12:36:56 AM" would become: 2012042100.3656

(In this case, if you'd use a integer representation, the result number will be bigger than an integer and it won't work.)

In order to do it, please use this function in HTML:

getyear(DateTime)*1000000+getmonth(DateTime)*10000+getday(DateTime)*100+gethour(DateTime)+ToDouble(GetMinute(DateTime))/100+ToDouble(GetSecond(DateTime))/10000