Variables are not read by the script

[Nourrahmcnean]

I got this error after running this script:

Let vMinDate=NUM('24/02/2021');
Let vMaxDate=NUM('27/02/2021');

TEMP:
Load
If(RowNo()=1, Date( $(vMinDate),'DD/MM/YYYY'), Date( $(vMinDate) + RowNo(),'DD/MM/YYYY')) as Tempdate
AutoGenerate(1)
while $(vMinDate) + RowNo() < $(vMaxDate);

Unexpected token: ')', expected one of: ',', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', ...

ERROR:

TEMP:

Load

If(RowNo()=1, Date( ,'DD/MM/YYYY'), Date( + RowNo(),'DD/MM/YYYY') >>>>>>)<<<<<< as Tempdate

AutoGenerate (1)

while + RowNo() <

# variables

[Or]

You can't num() on this string... it doesn't have a valid numeric representation. You'd have to make that value a date first if you want to use num() on it. Currently it's evaluating to null, as you can see in debug mode.

[Nourrahmcnean]

Thanks for your answer, I changed  num() to Date() but i got the same error 

Let vMinDate=Date( '24/02/2021','DD/MM/YYYY');
Let vMaxDate=Date( '27/02/2021','DD/MM/YYYY');

TEMP:
Load
If(RowNo()=1, $(vMinDate), $(vMinDate) + RowNo() ) as Tempdate
AutoGenerate (1)
while $(vMinDate) + RowNo() < $(vMaxDate);

Unexpected token: ')', expected one of: ',', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', ...

TEMP:

Load

If(RowNo()=1, , + RowNo() >>>>>>)<<<<<< as Tempdate

AutoGenerate (1)

while + RowNo() <

[Or · Accepted solution]

I suggest you run this in debug mode and see what the problem is. In this case, I think you'd need date#() rather than date(), though?