Why would a dataset that comes in daily sometimes change the date format?

kim_barragan0126 · 2025-03-26T19:35:31+00:00

There was an error rendering this rich post.

I have had this data set come in daily now for 6 months or more, and now for the second time in 1 month the data is wrong, and it seems to be an issue with the date format. Any reason why the date format would change? The correct format is 2025-03-24, but yesterday some of the dates formatted to 3/25/2025, therefore causing issues with incorrect data.

Find more posts tagged with

Accepted answers

MichelleH

@kim_barragan0126 It looks like this would have been caused by a format change in one of the inputs to your dataflow. I'd recommend using the FUZZY_PARSE_DATE function in the the Magic ETL formula tile to account for these different formats and convert them correctly into a date datatype.

All comments

MichelleH

kim_barragan0126

Thank you. I have not heard of this before, so I will see if I can figure it out. I am not sure why the format would change as the report is always the same - thanks!