UNIX_DATE

Returns the number of days since 1970-01-01.

Sample usage

UNIX_DATE(Order Date)

Syntax

UNIX_DATE( date_expression )

Parameters

  • date_expression - a Date or Date & Time field or expression.

Return data type

Number

Examples

Example formula Output

UNIX_DATE(DATE(2020,11,3))

18569

Notes

This function is not available for compatibility mode date types.

UNIX_DATE ignores the time parts of a Date & Time field or expression.