DAYOF
Syntax
DAYOF(date_string [, input_format])
Parameters
date_string
A text representing a valid date.
input_format
One of the keywords in the table below, specifying the date format of date_string.
Description
DAYOF returns the day of the month as a number for the date represented by the date_string. If input_format is not provided, the default keyword DELIM_M_D_Y will be used.
Examples
DAYOF("08/31/00") returns the number 31.
*
See DATE for additional information on valid date formats.