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 |
|
|
Inserts the current time as a date or number value |
currentTime() = 07/08/2024 |
|
|
Inserts the current date (midnight) as a date or number value |
currentDate() = 07/08/2024 |
|
|
Returns the numeric day of the week |
getDateDayOfWeek(07/ 08/2024) = 2 |
|
|
Returns the numeric day of the month |
getDateDayOfMonth(07/ 08/2024) = 8 |
|
|
Returns the numeric year of the date (Equation field's "Equation Type" must be set to "Numeric") |
getDateYear(07/08/2024) = 2024 |
|
|
Returns the numeric week of the year |
getDateWeek(07/08/2024) = 28 |
|
|
Returns the numeric month of the year |
getDateMonth(07/08/2024) = 7 |
|
|
Returns the last date of the month of a given date |
getDateLastDateOfMon th(07/08/2024) = 07/31/2024 |
|
|
Returns the number of working days between two dates |
netWorkDays(07/08/20 24, 08/06/2024) = 22 |
|
|
Returns the maximum of a list of values |
max(07/08/2024,08/06 /2024) = 08/06/2024 |
|
|
Returns the mean of a list of values |
mean(07/08/2024,08/0 6/2024) = 07/22/2024 |
|
|
Returns the median of a list of values |
median(07/08/2024,08/ 06/2024) = 07/22/2024 |
|
|
Returns the minimum of a list of values |
min(07/08/2024,08/ 06/2024) = 07/08/2024 |
|
|
Returns a random integer between two values |
randomInt(07/08/2024, 08/06/2024) = 07/20/2024 |
|
|
Returns the standard deviation of a list of values |
std(07/08/2024, 08/06/2024) = 01/21/1970 |
|
|
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.