Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to load some value to different dimension and one of them has to be Today Date.
this is the script
LOAD * INLINE [
Data_Scadenza, Banca_app, Importo
2020-07-24 00:00:00.000, 'USD - CREDEM C/C' , 500
$(Today()), 'USD - CREDEM C/C' , 350
];
and this is the result
how can i get the today date?
Try the following code
LET vToday = Today() ;
data:
LOAD * INLINE [
Data_Scadenza, Banca_app, Importo
2020-07-24 00:00:00.000, 'USD - CREDEM C/C' , 500
$(vToday), 'USD - CREDEM C/C' , 350
];
Try using variable like,
Let vToday=today();
Load * Inline [
Field
vToday
]
Try the following code
LET vToday = Today() ;
data:
LOAD * INLINE [
Data_Scadenza, Banca_app, Importo
2020-07-24 00:00:00.000, 'USD - CREDEM C/C' , 500
$(vToday), 'USD - CREDEM C/C' , 350
];
it works,
thanks a lot