Date saved as number instead of date (DDMMYYY) (M&D 2.1.1 Build #17)

Posted over 1 year ago by Jaroslaw Wojciech Gniazdowski

Post a topic
Answered
J
Jaroslaw Wojciech Gniazdowski

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)

0 Votes

Emma Camacho

Emma Camacho posted over 1 year ago Admin Best Answer

Hi Jaroslaw,

[Datasource].[TEST APP].[Expression].[text(date($(vS_Date),'DDMMYYYY'))]

or
[Datasource].[TEST APP].[Expression].[text(date(vS_Date,'DDMMYYYY'))]

depending if you need $ expansion,

regards, Emma

0 Votes


1 Comments

Emma Camacho

Emma Camacho posted over 1 year ago Admin Answer

Hi Jaroslaw,

[Datasource].[TEST APP].[Expression].[text(date($(vS_Date),'DDMMYYYY'))]

or
[Datasource].[TEST APP].[Expression].[text(date(vS_Date,'DDMMYYYY'))]

depending if you need $ expansion,

regards, Emma

0 Votes

Login or Sign up to post a comment