Brian Dunning's FileMaker Custom Functions

Julian ( vDate )

Calculate Julian Date

  Average rating: 4.8 (24 votes) Log in to vote

Makah Encarnacao   Makah Encarnacao
Soliant Consulting

Share on Facebook Share on Twitter

  Sample input:
Julian ("6/28/2012")
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Converts any date into the Julian date for that year. In the sample, the Julian date tells me that 180 days have passed since Jan 1st 2012.



comment   comment, VR
Jun 29, 2012
How about just =

1000 * Year ( date ) + DayOfYear ( date )

P.S. "This system is sometimes incorrectly referred to as "Julian Date", whereas the astronomical Julian Date is a sequential count of the number of days since day 0 beginning 1 January 4713 BC Greenwich noon..."

Log in to post comments.


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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: