PDF date import

[M_SBS_6]

Hi, I am importing a PDF into Power BI and the date column is showing as ABC123 and formatted as 7/31/2024. 

I have tried to convert this to a date but it errors: 

Dateformat.error. we couldn't parse the input provided as a date value. Details: 7/31/2024

Is there anything I can do to make this a date and format this as dd/mm/yyyy? 

[danextian · Accepted solution]

hi @M_SBS_6 ,

The date using the US culture  so you need to specfy the culture when changing the data type. You can change the format after loading it to the model.