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.