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

[EugeniaCastilla]

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

[Thiago_Justen_ · Accepted solution]

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

[EugeniaCastilla]

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..