Hi,
I am trying to use below load statement
LET vComp = weekday(today());
load
day,
column1
resident table1
where day = $(vComp);
but while reloading it gives an error as "Field not found -- Thu". whereas wheren "day = 'Thu' " condition is provided, then this load works
I also tried using chr(39) in variable declaration as
LET vComp = chr(39)&weekday(today())&chr(39);
but still not able to use it.
Can anyone provide me a solution for this.
Thanks for help
Aaditya