# QlikView Documents

Documents for QlikView related information.

# Julian calendar

Valued Contributor

## Julian calendar

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

)

))``````

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