FAQ: How to remove the time from the display of dates

Here’s another question we see a lot:
What is the best way to remove the time from the dates?

There are two ways you may wish to do this.
The first is to remove the time component from the data itself. That can be done with the DateTrunc function, which will truncate the date to the designated precision, like so:
‘DateTrunc(“day”, Date(“1980-05-22 8:45:30”))’
The second option is to remove the date from the display of the date, while retaining the value of the cell behind-the-scenes.
That is done via this menu on a column:

1 Like