Table of Contents

Formulas - Date

Sofia Teran Updated by Sofia Teran

Date

Formulas available:

  • AddDays
  • AddMonths
  • AddYears
  • Today
  • ToDate
Examples of use case of Date formulas:

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

Today - this This function returns the current date

Today()

ToDate

In this example we'll convert this string 20,12,2019 to a date 2020-12-20 like this:

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

How did we do?

Formulas - Comparison

Contact