Variable not working - Unexpected token: ',', expected one of

[aheavy95]

Hi all 

I am having a problem creating a new variable in my script

Up until now the variable vStartLoad was based of VStartDBAdjustment_Temp and the script worked fine.

Now I was asked to change it to the date I'm getting as the 'Value' - to the start of month of that date

So I created  VStartDBAdjustment_Temp2  and used it in vStartLoad  ,  and when I run the code I'm getting this error at the vStartLoad  declaration.

Does anyone know what am I doing wrong?

thanks

[Or]

Generally speaking, I'd suggest running in debug mode and seeing what actually happens in each line and what is placed in each variable.

Specifically, you may need to place the variable in quotes in this case -

Let someVariable = chr(39) & Date('$(VStartDBAdjustment_Temp2)','YYYY-MM-DD') & chr(39);