Poor quality data in what needs to be a data field

[SuzanneSte]

Hello,

When importing my data, many of my date/time fields are missing the leading 0 for single digit months.  As in 6/6/2023 as opposed to 06/06/2023.  When I convert these fields from text to date fields I get errors.  Is there a way either in Power BI or even in excel before importing to add the missing leading 0 when necessary?   Would appreciate your guidance

[v-binbinyu-msft · Accepted solution]

Hi @SuzanneSte ,

I test it in Power BI with different date, Power Query will change the data type with date type automically.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.