Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
LET vYesterDay = Date(Today()-3);
Load
If([AWDT_DATE_CONVERSION] = '$(vYesterDay)','Use','No') as FlagYesterday
from <>
just = vYesterDay,'Use','No'
Use LET vYesterDay = Today()-3;
Try with:
LET vYesterDay = Date(Today()-3);
let me know
Try like:
LET vYesterDay = Date(Today()-3);
Load
If([AWDT_DATE_CONVERSION] = '$(vYesterDay)','Use','No') as FlagYesterday
from <>
Thanks - this answer worked !