QUE CORPORATION - Using Filemaker pro X

Day()

Category: Date

Syntax: Day ( Date )

Parameters: Date ”Any valid date (1/1/0001 “12/31/4000), expression that returns a date, or field that contains a date.

Description: Returns the day of month (1 “31) for any valid date.

Examples:

Day ( "1/15/2000" ) = 15

Other functions can be referenced in Day() :

Day ( Get ( CurrentDate ))

returns the day of month for today.

Parameters in Day() can be calculated:

Day ( Get ( CurrentDate ) - 90 )

returns the day number for the date 90 days before today, which may not be the same as today's day number.