Table of Contents

Formulas - Date

Sofia Teran Updated by Sofia Teran

If is your first time with Formulas, please check our Getting Started guide here and our crash course here

Formulas available

  • AddDays
  • AddMonths
  • AddYears
  • Today
  • ToDate

AddDays

Add 3 days to the specified date 2020/01/01

AddDays(@my_date,3)

AddMonths

Add 4 months to the specified date 2020/01/01
AddMonths(@my_date,4)

AddYears

Add 2 years to the specified date 2020/01/01
AddDaysAddYears(@my_date,2)

Today

Get current date
Today()

ToDate

Convert date to a format like this 2020-12-20

ToDate(@dates,"%Y-%m-%d")

How did we do?

Formulas - Array

Formulas - Object

Contact