- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LOAD INLINE TODAY
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?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
];
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try using variable like,
Let vToday=today();
Load * Inline [
Field
vToday
]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
];
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it works,
thanks a lot
- Tags:
- works