https://community.qlik.com/t5/App-Development/Convert-date-serial-number-to-a-julien-date-serial-number/m-p/2081354#M88682 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/75666">@danaleota1</a>&nbsp; try below</P> <LI-CODE lang="javascript">LOAD Date, ((Date-MakeDate(0001,01,01))+1721426 as JulianDate FROM Source;</LI-CODE> Wed, 07 Jun 2023 20:53:37 GMT Kushal_Chawda 2023-06-07T20:53:37Z https://community.qlik.com/t5/App-Development/Convert-date-serial-number-to-a-julien-date-serial-number/m-p/2081183#M88675 <P>Hello&nbsp;</P> <P>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.&nbsp; &nbsp;</P> <P>&nbsp;</P> <TABLE width="420"> <TBODY> <TR> <TD width="108">date&nbsp;</TD> <TD width="139">num(date)</TD> <TD width="173">Julien Date Serial Number</TD> </TR> <TR> <TD>4/13/2012</TD> <TD>41012</TD> <TD>2456031</TD> </TR> </TBODY> </TABLE> Wed, 07 Jun 2023 13:47:51 GMT https://community.qlik.com/t5/App-Development/Convert-date-serial-number-to-a-julien-date-serial-number/m-p/2081183#M88675 danaleota1 2023-06-07T13:47:51Z https://community.qlik.com/t5/App-Development/Convert-date-serial-number-to-a-julien-date-serial-number/m-p/2081354#M88682 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/75666">@danaleota1</a>&nbsp; try below</P> <LI-CODE lang="javascript">LOAD Date, ((Date-MakeDate(0001,01,01))+1721426 as JulianDate FROM Source;</LI-CODE> Wed, 07 Jun 2023 20:53:37 GMT https://community.qlik.com/t5/App-Development/Convert-date-serial-number-to-a-julien-date-serial-number/m-p/2081354#M88682 Kushal_Chawda 2023-06-07T20:53:37Z