topic Date() function working as a measure but not in script in App Development

Date() function working as a measure but not in script

EugeniaCastilla — Sun, 24 Jul 2022 16:48:21 GMT

I have the following line of code:

[Data]:
LOAD
[ID_Factura],
[Date],
Date(Date#([Date],'M/D/YYYY'),'DD/MM/YYYY') as miDate,
[Market],
[Product],
[Units],
[Sales]
FROM [lib://AttachedFiles/Data Workshop.xlsx]
(ooxml, embedded labels, table is Data);

miDate appears as null when I load the script. However when I write the same exact format line in any visualization, it works fine:

Why might this be happening? I have deleted all the time Formats and everything just in case it was that and nothing ... please help

Re: Date() function working as a measure but not in script

Thiago_Justen_ — Sun, 24 Jul 2022 19:50:13 GMT

Try this Just to figure out what is happening:

Alt(

Date(Date([Date],'MM/DD/YYYY'),'DD/MM/YYYY'),

Date([Date])

) as miDate,

By seeing your table I guess the date field is already in date format.

Cheers

Re: Date() function working as a measure but not in script

EugeniaCastilla — Mon, 25 Jul 2022 07:05:59 GMT

Your formula worked ...

Please please! Explain why becasue I am not understanding anything. Up to this point my approach has always worked.... I don0t understand why it doesn't on the script but yes in visualizations..