Skip to content
English
More support Sign in
Login
  • There are no suggestions because the search field is empty.

Date Equation Functions

This article provides the date equation field functions available to use and their definitions.

Related Articles:

 

The following examples use July 8, 2024 as the date:

  Function Name

  Description

  Example with Result

 currentTime

  Inserts the current time as a date or number value

 currentTime() =     07/08/2024

 currentDate

  Inserts the current date (midnight) as a date or number value

 currentDate() =   07/08/2024

 getDateDayOfWeek

  Returns the numeric day of the            week (Equation field's "Equation Type" must be set to "Numeric")

 getDateDayOfWeek(07/ 08/2024) = 2

 getDateDayOfMonth

  Returns the numeric day of the            month (Equation field's "Equation Type" must be set to "Numeric")

 getDateDayOfMonth(07/  08/2024) = 8

getDateYear

 Returns the numeric year of the     date (Equation field's "Equation Type" must be set to "Numeric")

 getDateYear(07/08/2024) = 2024

 getDateWeek

  Returns the numeric week of the year (Equation field's "Equation Type" must be set to "Numeric")

               getDateWeek(07/08/2024) = 28

 getDateMonth

  Returns the numeric month of the year (Equation field's "Equation Type" must be set to "Numeric")

 getDateMonth(07/08/2024) = 7

getDateLastDateOfMonth

 Returns the last date of the month of a given date

    getDateLastDateOfMon  th(07/08/2024) =              07/31/2024

netWorkDays

 Returns the number of working days between two dates

 netWorkDays(07/08/20  24, 08/06/2024) = 22

max

 Returns the maximum of a list of       values

 max(07/08/2024,08/06   /2024) = 08/06/2024

mean

 Returns the mean of a list of values

 mean(07/08/2024,08/0   6/2024) = 07/22/2024

median

 Returns the median of a list of values

 median(07/08/2024,08/  06/2024) =   07/22/2024

min

 Returns the minimum of a list of values

 min(07/08/2024,08/     06/2024) = 07/08/2024

randomInt

 Returns a random integer between two values

 randomInt(07/08/2024,   08/06/2024) =   07/20/2024

std

 Returns the standard deviation of a list of values

 std(07/08/2024,   08/06/2024) =   01/21/1970

var

 Returns the variance of a list of values

 var(07/08/2024,   08/06/2024) =   06/13/101441

Notes:

  • The equation type must be set to "Date" to use some of these functions. 

  • The results may vary based on the specific selections you make in the settings of your date equation field. The basic examples provided above aim to offer a foundational understanding of how the function operates.

  • The Date Equation field does not support multiplication within expressions. For example, formulas like {Date} + (A * B), where A and B are numbers or number fields will not work as expected. You’ll need to calculate the result of A * B separately and reference that value in your date equation.