Date Equation Functions

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

 

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

 getDateDayOfWeek(07/ 08/2024) = 2

 getDateDayOfMonth

  Returns the numeric day of the            month

 getDateDayOfMonth(07/  08/2024) = 8

getDateYear

 Returns the numeric year of the date

 getDateYear(07/08/2024) = 2024

 getDateWeek

  Returns the numeric week of the year

               getDateWeek(07/08/2024) = 28

 getDateMonth

  Returns the numeric month of the year

 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: