I can't figure out my Script Error

[robinwiman]

I get a syntax error when I debug my scripts.

I've tried to make changes and revert them back with no luck.

I am not sure, but this part seems a bit worrying:

FROM >>>>>>.<<<<<<.\QVD\Budget.qvd (qvd)

where year(Date) >= Year(today())-1

It may be very hard to tell what seems to be the problem, but I have no clue where to start.

[Chanty4u]

missing semi coloun ;

\QVD\Budget.qvd (qvd)

where year(Date) >= Year(today())-1 ;

[Anil_Babu_Samineni · Accepted solution]

Try to debug in script, and what i found is one Comma added for last column,, That we need to remove

[Chanty4u]

or  set a vaariable and use this in condition

let vYear=Year(today())-1;

where year(Date) >= $(vYear);

or

where year(Date) >=' $(vYear)';

[tresesco]

Remove comma (,) after last field name [Item Group]

[robinwiman]

I had the Semicolon, but it is not shown in the error window. Thank you for your help, I appreciate it!

[robinwiman]

this did the trick! Thank you for your help, I appreciate it!

[stabben23]

Hi Robin,

maybe that year(Date) gives you a numeric year as its from a QVD, like 429xx

Or try where year(Date) >='2016' to se if it reload.

[robinwiman]

Thank you, this is the correct solution! Anil Babu Samineni posted the solution just a minute before you and I will mark his answer as correct. I appreciate your help!

[robinwiman]

Thank you, Staffan. I found the solution to the error being an excessive comma.