How to use a field into a for loop like an expression?

[karelibarcar]

Hi dear community,

Can you help me? I want to use a for loop, something like this:

For vYear = year(Start_Date) to Year(End_Date)

Load

Makedate($(vYear), Month(Date), Day(Date) as Date,

Start_Date,

End_Date

Resident myTable;

Next vYear;

This make me an error: the error was occured in For vYear = year(Start_Date) to Year(End_Date) 

and I don't know how to resolve this.

[sunny_talwar · Accepted solution]

Try this

LOAD Date(Start_Date + IterNo() - 1) as Date,
     Start_Date,
     End_Date
Resident myTable
While Start_Date + IterNo() - 1 <= End_Date;

[karelibarcar]

Perfect!

Thank you very much! That works fine!!

😊