Returns the day component of the date supplied. Any leading zeros are removed.
DAY ( <date_field or date> )
-
date_field or date: The date to use in the calculation.
Example: Create a field on the CUSTOMER table that shows just the day portion of a customer's date of birth.
DAY( [CUSTOMER.DATE OF BIRTH] )