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
http://www.soliantconsulting.com/

Share on Facebook Share on Twitter

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

  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.

 

Comments

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..."

http://en.wikipedia.org/wiki/ISO_8601#Ordinal_dates
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.