Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member


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.


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:



Version history
Last update:
‎10-16-2021 07:19 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: