Date and time functions let you perform a variety of different tasks with date, datetime, or time data.

For example, you can calculate the number of days between two dates, extract portions of a date, such as just the month, or find out the day of the week that corresponds to each date.

Date and time functions can sometimes be challenging to use correctly. In the Help, function topics describe the specific details of how each function works. For information about some general considerations when using date and time functions, see the following topics:

Function Description

AGE( )

Returns the number of elapsed days (the age) between a specified date and a specified cutoff date, or the current operating system date, or the number of elapsed days between any two dates.

CDOW( )

Returns the name of the day of the week for a specified date or datetime. Abbreviation for "Character Day of Week".

CMOY( )

Returns the name of the month of the year for a specified date or datetime. Abbreviation for "Character Month of Year".

CTOD( )

Converts a character or numeric date value to a date. Can also extract the date from a character or numeric datetime value and return it as a date. Abbreviation for "Character to Date".

CTODT( )

Converts a character or numeric datetime value to a datetime. Abbreviation for "Character to Datetime".

CTOT( )

Converts a character or numeric time value to a time. Can also extract the time from a character or numeric datetime value and return it as a time. Abbreviation for "Character to Time".

DATE( )

Extracts the date from a specified date or datetime and returns it as a character string. Can also return the current operating system date.

DATETIME( )

Converts a datetime to a character string. Can also return the current operating system datetime.

DAY( )

Extracts the day of the month from a specified date or datetime and returns it as a numeric value (1 to 31).

DOW( )

Returns a numeric value (1 to 7) representing the day of the week for a specified date or datetime. Abbreviation for "Day of Week".

EOMONTH( )

Returns the date of the last day of the month that is the specified number of months before or after a specified date.

GOMONTH( )

Returns the date that is the specified number of months before or after a specified date.

HOUR( )

Extracts the hour from a specified time or datetime and returns it as a numeric value using the 24-hour clock.

MAXIMUM( )

Returns the maximum value in a set of numeric values, or the most recent value in a set of datetime values.

MINIMUM( )

Returns the minimum value in a set of numeric values, or the oldest value in a set of datetime values.

MINUTE( )

Extracts the minutes from a specified time or datetime and returns it as a numeric value.

MONTH( )

Extracts the month from a specified date or datetime and returns it as a numeric value (1 to 12).

NOW( )

Returns the current operating system time as a Datetime data type.

SECOND( )

Extracts the seconds from a specified time or datetime and returns it as a numeric value.

STOD( )

Converts a serial date – that is, a date expressed as an integer – to a date value. Abbreviation for "Serial to Date".

STODT( )

Converts a serial datetime – that is, a datetime expressed as an integer, and a fractional portion of 24 hours – to a datetime value. Abbreviation for "Serial to Datetime".

STOT( )

Converts a serial time – that is, a time expressed as a fractional portion of 24 hours, with 24 hours equaling 1 – to a time value. Abbreviation for "Serial to Time".

TIME( )

Extracts the time from a specified time or datetime and returns it as a character string. Can also return the current operating system time.

TODAY( )

Returns the current operating system date as a Datetime data type.

UTOD( )

Converts a Unicode string containing a formatted date to an Analytics date value. Abbreviation for "Unicode to Date".

WORKDAY( )

Returns the number of workdays between two dates.

YEAR( )

Extracts the year from a specified date or datetime and returns it as a numeric value using the YYYY format.