# 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 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: