Convert date serial number to a julien date serial number

[danaleota1]

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

[Kushal_Chawda]

@danaleota1  try below

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