Notifications
Clear all
Power Query
3
Posts
3
Users
0
Reactions
9
Views
Topic starter
I get the following error after I transform a date into a month number. I want to sort on month number and or date.
I get the correct month number in the column but unable to sort.
DataFormat.Error: We couldn't parse the input provided as a DateTime value.
Details:
2/3/2020 11:58:00 PM H
Do you need a example file?
Thanks
Robb
Posted : 20/09/2020 11:26 pm
Hi Robert
Yes please, a sample of your original Datetime column and also with column of Month, with the error that you mentioned
Posted : 21/09/2020 1:51 am
Hi Robert,
Have you set the data type for the InDate - Copy.1 column as date before trying to extract the Month number?
Mynda
Posted : 21/09/2020 5:05 am
