Loop

jsshivalik

Hi

I want to loop from start date to end date. How I can add 1 Day to start date till it is equal to end date

Thanks

AK

Use CALCDATE.

muca

// sDate = starting date (today for example)
// eDate = ending date (end of month for example)

sDate:=TODAY;
eDate:=CALCDATE('<CM>',sDate);
REPEAT
sDate:=sDate+1;
// do something using sDate (Starting Date)
UNTIL sDate=eDate;

kriki

Better:

FromDate := TODAY;
ToDate := FromDate + 2;
FOR d := FromDate TO ToDate DO BEGIN
MESSAGE('%1',d);
END;

RockWithNAV

Is that Solved OR you still struggling?

AK

Use CALCDATE.

muca

// sDate = starting date (today for example)
// eDate = ending date (end of month for example)

sDate:=TODAY;
eDate:=CALCDATE('<CM>',sDate);
REPEAT
sDate:=sDate+1;
// do something using sDate (Starting Date)
UNTIL sDate=eDate;

kriki

Better:

FromDate := TODAY;
ToDate := FromDate + 2;
FOR d := FromDate TO ToDate DO BEGIN
MESSAGE('%1',d);
END;

RockWithNAV

Is that Solved OR you still struggling?