DATEPART

Returns just the date part from a value that includes the date and time.

DATEPART ( <date_field or date> )

  • date_field or date: The date field to use in the calculation.

Note: dates in Audiences need to be formatted as either YYYY-MM-DD or MM/DD/YYYY. Entering a date as 01-02-2023 would be read as Jan-2 not 1-Feb.

Example: create a field on the CUSTOMER table that returns just the date portion of each customer first purchase.

DATEPART([CUSTOMER.FIRST_PURCHASE_DATE_AND_TIME])