Julian ( vDate )

Calculate Julian Date

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

Makah Encarnacao
Soliant Consulting
http://www.soliantconsulting.com/

Sample input:

Julian ("6/28/2012")

Sample output:

2012180

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

Let( [
zDate = GetAsDate( vDate )
];
Year( zDate) & Right( "000"& zDate+1 - GetAsDate( "1/1/" & Year( zDate)); 3)
)

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, 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

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