Skip to main content

Date Equation Examples

Listed below are several examples of date equations demonstrating date functions in action.

DAYOFMONTH

The DAYOFMONTH function generates the day number of the month given a date value. 

Below is a sample equation using the DAYOFMONTH function.

2022-01-20_13-48-52.png

Below are the results of this sample equation using the DAYOFMONTH function.

YMUuQQtPr2kSpkmrCxLBXTBteMe_IOj6QQ.png

DAYOFWEEK

The DAYOFWEEK function generates a numeric representation for the day of the week that the given date falls on. The generated value will be a number from 1-7 where 1 is Sunday and 7 is Saturday.

Below is a sample equation using the DAYOFWEEK function.

2022-01-20_13-50-20.png

Below are the results of this sample equation using the DAYOFWEEK function.

JcomyXsKCxZ-IeWk2Onkt3gu8DS3U3P73w.png

DAYOFYEAR

The DAYOFYEAR function generates a numeric representation for the day of the year which the given date falls on. The generated value will be a number from 1-366.

Below is a sample equation using the DAYOFYEAR function.

2022-01-20_13-51-39.png

Below are the results of this sample equation using the DAYOFYEAR function.

EKpnrWbzgefM0kYfvbzh8n5T9VSgw25C9Q.png

DATEDIFF

The DATEDIFF function generates the total amount of days in between the given date values.

Below is a sample equation using the DATEDIFF function, where we get the number of days between the start and end of a Date Range field: 

DATEDIFF({Date Range - End Date},{Date Range - Start Date})+1

LAST_DAY

The LAST_DAY function generates the last date of the month of the given date value. The generated value will be a date format.

Below is a sample equation using the LAST_DAY function.

2022-01-20_13-53-23.png

this sample equation using the LAST_DAY function.

X134eISmxfLyNA5sFaDrpz0_dKG3n0AMTA.png

YEAR

The YEAR function generates the year of the given date. The output will be a single numeric representation of the year value.

Below is a sample equation using the YEAR function.

2022-01-20_14-46-10.png

Below are the results of this sample equation using the YEAR function.

BK9JuC6QR4q7Ovi9rNShG1GufawGtGBIdg.png

MONTH

The MONTH function generates the month of the given date within its numeric value. The output will be a single numeric representation of the month value.

Below is a sample equation using the MONTH function.

2022-01-20_14-47-30.png

Below are the results of this sample equation using the MONTH function.

4dOFT_KQmaM7tNM8p0Ej3WSzno5R0fawug.png

MONTHNAME

The MONTHNAME function generates the name of the month of the given date. The output will be a text representation of the month value.

Below is a sample equation using the MONTHNAME function.

2022-01-20_14-48-36.png

Below are the results of this sample equation using the MONTHNAME function.

s_WgQ5tGuiIa4XnnivSYXIWHM9L60_U2kw.png

NOW

The NOW function generates the current time. This function, unlike the other Date Functions, is not to be used with any fields as input (as illustrated in the image below). The value is saved upon record creation and updated upon saving any type of edit.

Below is a sample equation using the NOW function.

2022-01-20_14-49-31.png

Below are the results of this sample equation using the NOW function.

cJTM1rSnDt7xe1Gcasq-RBIGzbiZ4d09Ag.png

WEEKOFYEAR

The WEEKOFYEAR function generates the week number that the given date falls within. The output will be a single numeric representation of the week.

Below is a sample equation using the WEEKOFYEAR function.

2022-01-20_14-50-29.png

Below are the results of this sample equation using the WEEKOFYEAR function.

RhWVA8Dt384NOwQgFf9VbemKX7ZhvMGOoA.png

Back to top