Julian ( vDate )
Calculate Julian Date
Average rating: 4.8 (24 votes) Log in to vote
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.
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..."
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.