Date Expressions

Cohesive supports simple calculations involving dates. You can adjust dates (presented in any common ISO 8601 format, likeYYYY-MM-DD hh:mm:ss a orYYYY/MM/DD) by days, weeks, months, or years.

Example 1: Description to add 5 days to the orderDate field

ADD_DAYS(orderDate, 5)

Example 2: Description to add 5 weeks to the orderDate field

ADD_WEEKS(orderDate, 5)

Example 3: Description to subtract a month from the orderDate field

ADD_MONTHS(orderDate, -1)

Example 4: Description to subtract a year from the orderDate field

ADD_YEARS(orderDate, -1)