Convert integer into date

mcaverly · 2009-11-04

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 · 2009-11-04

01011900D + 16783

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

Luc_VanDyck · 2009-11-04

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 · 2009-11-04

Thanks. It works.

DenSter · 2009-11-04

matttrax wrote:

01011900D + 16783

Cool I didn't know it worked like that

Luc_VanDyck · 2009-11-04

I feel stupid now :oops:

DenSter · 2009-11-04

Luc Van Dyck wrote:

I feel stupid now :oops:

Yeah so do I

Howdy, Stranger!

Quick Links

Categories

Convert integer into date

Comments