Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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]
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]
Thank you so much!