count days between 2 Dates

SimoGsi · 2004-10-28

Hi all,
Please, How to calculate the number of days between 2 Dates?!!
i ve tried this
i:=date2-date1 ;

Example :
i:=12/09/2004-01/09/2004
when i display the value of <i> it has 3 instead of 11
i dont know what is the problem!!

Thank you

Morten_Solberg · 2004-10-28

FirstDate := 010904D;
LastDate := 120904D;
TempDate := FirstDate;
REPEAT
i += 1;
TempDate := CALCDATE('+1D',TempDate);
UNTIL TempDate = LastDate;
MESSAGE(FORMAT(i));

Savatage · 2004-10-28

http://www.mibuso.com/forum/viewtopic.p ... +two+dates

cmoran · 2004-10-29

There is no problema if you'll try this:

date1 := 011004d;
date2 := 311004d;
MESSAGE(FORMAT(date2-date1));

You see 30 days

count days between 2 Dates

Comments

Categories