If statement with variable

[timsaddler]

Hello
I have this line in my script :-

([AWDT_DATE_CONVERSION] = Today()-3,'Use','No') as FlagYesterday

can i replace Today()-3 with a variable

vYesterDay = Today()-3;

If so, what would be the syntax?

Thanks

[Anonymous]

just = vYesterDay,'Use','No'

[rajeshvaswani77]

Use LET vYesterDay = Today()-3;

[alexandros17]

Try with:

LET vYesterDay = Date(Today()-3);

let me know

[senpradip007 · Accepted solution]

Try like:

LET vYesterDay = Date(Today()-3);

Load
If([AWDT_DATE_CONVERSION] = '$(vYesterDay)','Use','No') as FlagYesterday

from <>

[timsaddler]

Thanks - this answer worked !