Error in Date column

Hello Anonymous 

If in the Excel-file the date-field is formated as date, you should normaly get no errors. In your case this might not be the case. Therefore you need to check the date type (american, english) and not applying a Table.TransformColumnTypes but a Table.TransformColumns instead using a Date.From(_, culture) Function. But without any Query/data I'm not able to help you further.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

You can approach this a few ways:

1. Fix the dates in your source.
2. Try converting the "date" to a real date. The Date.From or Date.FromText functions may help, and you can wrap them in a try/otherwise statement. So:

try Date.FromText([DateField]) otherwise null

That will try to convert the date-looking-thing in the DateField from text to a date. If it works, great. If not it returns null, which isn't an error.

If you need further help, please post sample data as text so we aren't guessing what your "dates" look like or what the errors are.