DAYOFMONTH

Returns the day within a month of a date supplied. Any leading zeros are removed.

This is compatible with the ODBC 3.0 AND ANSI SQL 92 Standards.

DAYOFMONTH( <date_field or date> )

  • date_field or date: The date 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 to return the day of the month that the transaction was made.

DAYOFMONTH( [TRANSACTIONS.PURCHASE DATE] )

Results:

  • Returns 18 for June 18th
  • Returns 1 for January 1st
  • Returns 4 for May 4th