How to add column with a current date?

[jacek27031]

Hi,
I would like to add a column with the current date in the format 'M/D/YYYY' when loading data. I tried as below but after loading the data, no date is displayed
LOAD COUNTRY,
"Report_Type",
"Part number" as "% Product ID",
"Think vs Idea",
"Inventory date",
"Inventory quantity",
'$ (vToday)' as [%Date];

SQL SELECT COUNTRY,
"Report_Type",
"Part number" as "% Product ID",
"Think vs Idea",
"Inventory date",
"Inventory quantity",
FROM "DM_EMEA_BIZ" .MS. "DASI_QS";

Thanks in advance for any tips!

[Iswarya_ · Accepted solution]

Hi @jacek27031 ,

Make sure a variable 'vToday' is created before the script like below:

Let vToday=Date(Today(),'M/D/YYYY');

Also, make sure there is no space between dollar and (

'$(vToday)' as [%Date]

[jacek27031]

Thank you so much!