Convert integer into date

mcaverly

I would like to convert an integer value into the date (ig. converting 16783, number of days since 1/1/1900. The result would be 12/12/1945) .

Thanks in advance for your advice and/or inputs.

matttrax

01011900D + 16783

Although Navision says that that is 12/14/1945.

Luc_VanDyck

You can use CALCDATE to add x-number of days since a given date. But as the max. number that can be added is 9999, you'll have to do the calculation twice. The first time for the first 9999 days, the 2nd time for the remaining number of days:

datDate := CALCDATE(STRSUBSTNO('<+%1D>',9999),DMY2DATE(1,1,1900));
datDate := CALCDATE(STRSUBSTNO('<+%1D>',16783 - 9999),datDate);
MESSAGE('1/1/1900 + 16783 days = %1',datDate);

which gives 14/12/1945 as the result.

mcaverly

Thanks. It works.

DenSter

matttrax wrote:

01011900D + 16783

Cool I didn't know it worked like that

Luc_VanDyck

I feel stupid now :oops:

DenSter

Luc Van Dyck wrote:

I feel stupid now :oops:

Yeah so do I