Forum Discussion
How to standardize different time formats
Hi all, Stuck in a dilemma, unfortunately a report is sent to me with a a date column that has all kind of different formats. Here are the 3 types: Is there any formula or script that could stan...
Perhaps you have any flag which could say which day format is used in concrete report. Something in filename or in file header or like.
Since you mentioned Power BI I assume you use Power Query to load reports. Another option with it could be to check if there are any errors in column with dates after conversion. If they are to add another conversion step with another culture. However, that could work only if you definitely have in each report dates with day after 12th for the month.
Checking date by date won't work, 8/4/2024 always will be recognized as date in your regional format if not to instruct Excel we shall use another one.