UNIX_DATE

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.

Related resources

• Dates and times
• Calculated fields
• Looker Studio function list