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

kim_barragan0126
kim_barragan0126 Member
in Datasets

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.

image.png

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

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

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

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

  • kim_barragan0126
    kim_barragan0126 Member

    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!

Categories