Forum Discussion
Date Format
Hi, I'm importing a PDF into power bi but the date withing the PDF is formatted as 1/22/2024.
Within Power Query I tried to change to a Date but it errors:
DateFormat.error: we couldn't parse thr input provided as a Date value.
Any idea how to resolve this please?
Hi, M_SBS_6
According to your description, you have an error in converting the time format, according to my test, the format "1/22/2024" can be converted normally. You can try the following to solve the problem.
1. Please check whether all the data formats of your date columns are unified.PDF:
Test:
2. If the format is uniform, you can modify the query in Power BI Advanced Editor to use the 'Date.FromText' function to specify the format of the date string. For example, if the date is formatted as 'M/dd/yyyyy' (e.g., '1/22/2024'), the following M code can be used:
let
Source = ... ,
ConvertedDate = Table.TransformColumns(Source, {"YourDateColumnName", each Date.FromText(_, "en-US", "M/dd/yyyy"), type date})
in
ConvertedDateBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
Hi M_SBS_6
Can you please see the below ticket
https://community.fabric.microsoft.com/t5/Desktop/how-to-format-dates-of-different-excel-files-in-power-query/m-p/3696411#M1205499
I have attached pbix file in this ticket to correct the date format.
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the ThumbUp 👍 button if this comment helps you.
Thanks
Pijush
LinkedinHi, M_SBS_6
According to your description, you have an error in converting the time format, according to my test, the format "1/22/2024" can be converted normally. You can try the following to solve the problem.
1. Please check whether all the data formats of your date columns are unified.PDF:
Test:
2. If the format is uniform, you can modify the query in Power BI Advanced Editor to use the 'Date.FromText' function to specify the format of the date string. For example, if the date is formatted as 'M/dd/yyyyy' (e.g., '1/22/2024'), the following M code can be used:
let
Source = ... ,
ConvertedDate = Table.TransformColumns(Source, {"YourDateColumnName", each Date.FromText(_, "en-US", "M/dd/yyyy"), type date})
in
ConvertedDateBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
