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

Formula Result

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.

Related resources

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue