Julian ( datetime )

Julian Date and Time for calculations

Average rating: 4.3 (36 votes) Log in to vote

Roger Biel
2Geckos Consulting, LLC
www.2geckos.com

Sample input:

Julian( "" )
Julian( Get( CurrentTimeStamp ) )
Julian( "12/31/1969 0:00:00 AM" )

Sample output:

1213825758
1213826524
0

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

// Julian( datetime )
// 2Geckos  www.2Geckos.com

Let( [  datetime = If( IsEmpty( datetime ) ; Get ( CurrentTimeStamp ) ; datetime  ) ;
        datetime = If( IsValid( GetAsTime ( datetime ) ) ; datetime  ; datetime   & " "  & Get ( CurrentTime ) ) ;

           julian =  DayOfYear ( datetime   )  + ( (  Year ( datetime  ) - 1970 ) * 365 ) ;
           julianseconds = julian *24 * 60 * 60 ;
           julianseconds = julianseconds + Hour ( datetime  ) * 60 * 60 ;
           julianseconds = julianseconds + Minute ( datetime  ) * 60  ;
           julianseconds = julianseconds + Seconds ( datetime  )   ; 

         julianyear = Int( julian / 365 ) + 1970 ;
         julianmonth = Int( ( julianyear - 1970 ) / 12 ) ;
         julianday =  julianmonth - ( julianyear  / 12 ) 
      ] ;

julianseconds  
)

A Julian Timestamp well suited for calculations that uses both Date and time.
The resulting number is the number of seconds since Jan 1, 1970.
No parameters uses the current date and time.

Comments

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

Julian ( datetime )

Comments

Support this website.

Support this website.