topic How to use a field into a for loop like an expression? in App Development

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

karelibarcar — Sat, 16 Nov 2024 04:24:57 GMT

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 — Thu, 10 Oct 2019 16:48:01 GMT

Try this

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

karelibarcar — Thu, 10 Oct 2019 17:08:49 GMT

Perfect!

Thank you very much! That works fine!!

😊