Date Expressions
Date expressions provide functions for manipulating and formatting date and time data within your application. This category includes operations for calculating date differences, adding or subtracting time intervals, and formatting dates for display.
Date
A specific calendar date.
1
Date Constant
Date
Date List
A collection of dates arranged in a sequence or list format.
>=1
Date Constant
Date List
Date & Time
A specific point in time including both the date and the time of day.
1
Date & Time Constant
Date & Time
Date & Time List
A collection of date and time values arranged in a sequence or list format.
>=1
Date & Time Constant
Date & Time List
First Day
Returns the first day of a month of a specific date.
1
Date
Date
Day of
Extracts the day from a given date.
1
Date
Whole Number
Month of
Extracts the month from a given date.
1
Date
Whole Number
Year of
Extracts the year from a given date.
1
Date
Whole Number
Calculate Age
Determines the age of a person or entity based on their date of birth and a reference date.
2
Date
Whole Number
Day of the Week
Identifies the specific day of the week for a given date.
1
Date
Whole Number
Day of the Year
Indicates the ordinal day number within a year.
1
Date
Whole Number
Date Difference
Calculates the number of days between two given dates.
2
Date
Whole Number
Add Days
Adds a specified number of days to a given date.
2
1st is a Date
2nd is a Whole Number
Date
Add Months
Adds a specified number of months to a given date.
2
1st is a Date
2nd is a Whole Number
Date
Add Years
Adds a specified number of years to a given date.
2
1st is a Date
2nd is a Whole Number
Date
Subtract Days
Subtracts a specified number of days from a given date.
2
1st is a Date
2nd is a Whole Number
Date
Subtract Months
Subtracts a specified number of months from a given date.
2
1st is a Date
2nd is a Whole Number
Date
Subtract Years
Subtracts a specified number of years from a given date.
2
1st is a Date
2nd is a Whole Number
Date
Today()
Returns the current date and time.
1
NA
Date and Time
Last updated