Qlik Community

QlikView Documents

Documents for QlikView related information.

Julian calendar

Taoufiq_ZARRA
Valued Contributor

Julian calendar

Hi All,

julien.PNG

                                                     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 :

Capture.PNG

 

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 :

Capture.JPG

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    


        )


    ))

 

Attachments
Version history
Revision #:
1 of 1
Last update:
‎2020-01-09 12:16 PM
Updated by:
 
Contributors