Brian Dunning's FileMaker Custom Functions

JDToDate ( JulianDayNumber ; gregorian )

converts a Julian Day number into a Filemaker date

  Average rating: 3.9 (34 votes) Log in to vote

Theo Ros   Theo Ros

Share on Facebook Share on Twitter

  Sample input:
JDToDate ( 2453521 ; 1 )
  Sample output:
a date May 30, 2005

  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 )



Hezekiel   Hezekiel, Finland
Mar 8, 2017
This function worked for me, but it seems to put all dates of January into the PREVIOUS year.

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.