Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
danaleota1
Creator
Creator

Convert date serial number to a julien date serial number

Hello 

I am trying to convert my num(Date) date serial number used in QLIK (1900 date system) to a Julien Date Serial number in order to complete an incremental load in the load editor where I will be converting max(Date) to return a max date in the Julien Date Serial format. The example below is converting 4/13/2012.   

 

date  num(date) Julien Date Serial Number
4/13/2012 41012 2456031
Labels (2)
1 Reply
Kushal_Chawda

@danaleota1  try below

LOAD Date,
     ((Date-MakeDate(0001,01,01))+1721426 as JulianDate
FROM Source;