Hi ravi,
its just because for the code you have written there is no no value in the date field.
you can check, your code works fine when you enter vNWeek = 6
As per my understanding, you want the date range even if it is not in your date Field. If this is the case, then you have to autogenerate the date seperately and have to link to your date field.
Use the following code to autogenerate:
LET MinYear = year(today())-2;
LET MaxYear = Year(today());
LET MonthMin = 1;
LET MonthMax = 12;
for Y = $(MinYear) to $(MaxYear)
for M = $(MonthMin) to $(MonthMax)
for D = 1 to 30
LedgerTemp:
LOAD
$(Y) AS Year,
$(M) AS Month,
MakeDate($(Y),$(M),$(D)) as Date
AUTOGENERATE(1) ;
Next D
NEXT M
NEXT Y
Hope this solves your Issue.
If not understood, just copy and paste this code to your script pane and remove the current one. Then you can see what you want.
Regards
