JDToDate ( JulianDayNumber ; gregorian )
converts a Julian Day number into a Filemaker date
Average rating: 3.9 (34 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Converts a Julian Daynumber into a FileMaker date
a JD number is based on November 24 -4713 (=day zero Gregorian)
which is January 1 -4712 (January 1 4713 BC) Julian.
In: JulianDayNumber - a Julian Daynumber
gregorian - optional: if <> 0 or empty use Gregorian calendar
if 0 use Julian calendar
defaults to Gregorian calendar
Return type: Date
Syntax: JDToDate ( jd ; 1 )
Mar 8, 2017
|This function worked for me, but it seems to put all dates of January into the PREVIOUS year.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.