# 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.

## Related resources

- [Dates and times](https://docs.cloud.google.com/data-studio/dates-and-times)
- [Calculated fields](https://docs.cloud.google.com/data-studio/about-calculated-fields)
- [Data Studio function list](https://docs.cloud.google.com/data-studio/function-list)