Julian calendar

Taoufiq_Zarra — Wed, 21 Sep 2022 17:07:35 GMT

Hi All,

Joseph Justus Scaliger (5 August 1540 – 21 January 1609)

History :

To link together astronomical phenomena that occur at very different times, astronomers use the Julian Day, which counts the days one by one. This way of counting days is derived from the Julian period created by Scaliger (Joseph-Juste 1540-1609). It is related to Julius Caesar's Julian calendar, because the period counts in Julian years.

From this date (-4712), astronomers count the days one by one.

For a more precise date, the Julian date is used: time passed since 1 January -4712 expressed in days and decimals.

Examples :

Qlikview & Qliksense :

To convert this date to an ordinary date, the first thing to do is to extract the year :

if we take the following example: 120001

the steps for converting are :

therefore, to convert a joulian date to an ordinary date, the formula :

Date( MakeDate( 1900 + (left(text(Julian_Date),1) * 100) + mid(text(Julian_Date),2,2) ) + (right(text(Julian_Date),3) - 1 ) )

to extract the year

Year(Date( MakeDate( 1900 + (left(text(Julian_Date),1) * 100) + mid(text(Julian_Date),2,2) ) + (right(text(Julian_Date),3) - 1 ) ))

to extract the month

Month(Date( MakeDate( 1900 + (left(text(Julian_Date),1) * 100) + mid(text(Julian_Date),2,2) ) + (right(text(Julian_Date),3) - 1 ) ))

to extract the day

Day(Date( MakeDate( 1900 + (left(text(Julian_Date),1) * 100) + mid(text(Julian_Date),2,2) ) + (right(text(Julian_Date),3) - 1 ) ))

article Julian calendar in Member Articles

Julian calendar