Round Off Time in Date Field

To round the time of a date in a given column to 00 (midnight), you can utilize the DATE expression. This expression effectively removes the time component from the date time column, setting it to 00:00:00.

• Identify the column containing the date-time values that you wish to round.
• Use the expression date([datecolumn])
• Replace [datecolumn] with the name or reference to the column containing the date-time values.

Example:

     date([date3])

Furthermore, if you wish to convert the datetime to date at the dashboard level, you can utilize the pre-defined DATE function as shown below.