Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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..