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.

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

 

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.

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

 

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.

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

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.

this sample equation using the LAST_DAY function.

 

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.

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

 

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.

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

 

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.

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

 

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.

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

 

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.

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