Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
@danaleota1 try below
LOAD Date,
((Date-MakeDate(0001,01,01))+1721426 as JulianDate
FROM Source;