Functions (all)

DayNumber

Function Name:

DayNumber

Description:

If you counted all the days since January 1st, 0001 AD (counting that day as day 1), this function will return the day number for any given date. For example, the day number for 1st January, 2008, is 733,044.

This function is affected by the changeover date for the Gregorian calendar as specified in Preferences (i.e. either 1582 or 1752).

Minimum FH Version:

4.0

No. of Parameters:

1

Return Type:

Number. The day number.

Parameter 1:

A date.  If the date specifies a year, but no month, it will be treated as month 1.  If it does not specify the day, it will be treated as day 1.

Examples:

=DayNumber(%INDI.BIRT.DATE%)
=DayNumber(DateAt(2008,1,1))