Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I want to loop from start date to end date. How I can add 1 to start date till it is equal to end date
IF Rec.FINDSET THEN
UNTIL Rec.Next = 0;
I want to add 1Day to Start Date till it becomes equal to End Date . In this case i don't want to use Setrange.
StartDate:=CALCDATE('< +1D >',TODAY); //here I'm adding 1 day to Today's date.
There is one issue . If EndDate = 11/03/2018 . Start Date = 01/03/2018. When i loop according to the above Code it display Data only till 10/03/2018. Since at this Stage Start Date becomes equal to EndDate then it should not go in Repeat Loop which i think so.
Put the code
StartDate:=CALCDATE('< +1D >',TODAY);
inside the REPEAT UNTIL loop.