Reference > Functions reference > Date functions > Day
 

Day

Returns a number from 1 to 31, for the day of the month on which a date occurs.

Format 

Day ( date )

Parameters 

date - any calendar date

Data type returned 

number

Originated in 

FileMaker Pro 6.0 or earlier

Description 

Use the Day function, for example, to identify the day of the month on which payments are due.

Example 1 

Day ( "5/15/2019" ) returns 15. This example assumes that the system date format is MM/DD/YYYY.

Day ( DateSold ) returns the day of the month stored in DateSold.

Example 2 

Displays the text Beware the Ides of March only when the day of the month returned by Get ( CurrentDate ) is 15 and the month returned by Get ( CurrentDate ) is 3; otherwise it displays nothing.

If (
   Day ( Get ( CurrentDate ) ) = 15 and Month ( Get ( CurrentDate ) ) = 3;
   "Beware the Ides of March" ;
   ""
)

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas