We use cookies to try and give you a better experience in Freshdesk.
You can learn more about what kind of cookies we use, why, and how from our Privacy policy. If you hate cookies, or are just on a diet, you can disable them altogether too. Just note that the Freshdesk service is pretty big on some cookies (we love the choco-chip ones), and some portions of Freshdesk may not work properly if you disable cookies.
We’ll also assume you agree to the way we use cookies and are ok with it as described in our Privacy policy, unless you choose to disable them altogether through your browser.
Hi M&D users,
I'm struggling with a variable that is changed to number despite the fact that it's created in QLIK as date variable DDMMYYYY, M&D changes this to number:
[Datasource].[TEST APP].[Variable].[vS_Date] (vS_Date being Date(Makedate(vD_CurrentYear, vD_CurrentMonth, vD_CurrentDay), 'DDMMYYYY')
The file created in folder has below format:
File_45014.xlsx - instead of File_29032023.xlsx
Is it possible to change it in M&D expression field (attached) somehow?
Attachments (1)
vSDate.png
8.01 KB
0 Votes
Emma Camacho posted over 1 year ago Admin Best Answer
Hi Jaroslaw,
[Datasource].[TEST APP].[Expression].[text(date($(vS_Date),'DDMMYYYY'))]
0 Votes
1 Comments
Emma Camacho posted over 1 year ago Admin Answer
Hi Jaroslaw,
[Datasource].[TEST APP].[Expression].[text(date($(vS_Date),'DDMMYYYY'))]
0 Votes
Login or Sign up to post a comment