In this article, I provide useful expressions to:

  1. format dates
  2. round datesĀ 

(1) Formatting dates

Date to datetime

your_column.toDateTime()

Datetime to date

your_column.toDate()

Datetime to text string

your_column.day()

your_column.week()

your_column.month()

your_column.year()

(2) Rounding dates

Round down to the closest day/week/month/year

your_column.startOfDay()

your_column.startOfWeek()

your_column.startOfMonth()

your_column.startOfYear()

---------

Have a question? šŸ§

We're on standby to help! To chat with us, click the blue Intercom button in the bottom right of Trevor's interface.

Did this answer your question?