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