Forum Discussion
Query "modified Date" error
So.... the issue was the date format and I had been trying to correct that error by setting the date local on that column. What I didn't realize in the beginning was that I had a second date column with the same issue. By setting both date columns to date locale at the same time enabled the query to remove the error.
Hi,
The error is probably that power bi is trying to parse the value 21 as a month.
One solution could be by following the solution here but with a few changes.
So first split the column
Use "/" as your delimiter
Now you should have three columns, one containing days, one containing months and one containing year and time. Split the year/time column with space as your delimiter giving you a total of 4 columns.
It's a good idea to rename the columns to something like, Year,Month,Day and Time so you'll know which is which
If your new column containing your time data is a time datatype, change it to text.
Now create a custom column using this code
Text.Combine({Number.ToText([Year]),Number.ToText([Month]),Number.ToText([Day])},"/") & " " & [Time]Lastly change it to a datetime and it should work.
Hi Gordon, Thank you for the feedback! Unfortunately the date field is used in several queries and a bridging query so i would have to basically rebuild the model to test your solution. I can't do that now because I am in the middle of a seminar.
So.... the issue was the date format and I had been trying to correct that error by setting the date local on that column. What I didn't realize in the beginning was that I had a second date column with the same issue. By setting both date columns to date locale at the same time enabled the query to remove the error.