DATE Function
/documentation/pages/Ref/Api/Functions/Data Type/Date and Time Functions/DATE Function.xml
Returns the current system date.
Get Current Date/Time Function
/documentation/pages/Ref/Api/Functions/Data Type/Date and Time Functions/Get Current Date__SLASH__Time.xml
Gets the current date or time.
UI_GET_DATE Function
/documentation/pages/Ref/Desktop_Api/UI Functions/UI Get/UI_GET_DATE Function.xml
Prompt user for date.
date_to_utc_date Function
/documentation/pages/Ref/Api/Functions/Data Type/Date and Time Functions/date_to_utc_date Function.xml
Convert a date or time to a UTC date-time
date_from_utc_date Function
/documentation/pages/Ref/Api/Functions/Data Type/Date and Time Functions/date_from_utc_date Function.xml
Convert a UTC date-time to a date or time
date_quarternumber Function
/documentation/pages/Ref/Api/Functions/Data Type/Date and Time Functions/date_quarternumber Function.xml
Takes as date or time value and returns the Quarter in which the date falls
DATE_FORMAT Function
/documentation/pages/Ref/Api/Functions/Data Type/Date and Time Functions/DATE_FORMAT Function.xml
Formats a date value using a user defined format string
FixDateString Function
/documentation/pages/Ref/Api/Functions/Data Type/Date and Time Functions/FixDateString Function.xml
Takes a date string and a date format and transforms the date string so that it matches the format that Alpha Five expects (based on the current Regional Settings configuration). The year portion MUST be the last part of the date format. I.e. Does not support formats like YYYY/mm/dd
SQL_DATE Function
/documentation/pages/Ref/Api/Functions/SQL Helper Functions/SQL_DATE Function.xml
A date value.
DATE_VALUE Function
/documentation/pages/Ref/Api/Functions/Data Type/Date and Time Functions/DATE_VALUE Function.xml
Returns a date value. Errors if date is out of range