Support many date formats in Power Query Date Parse

[ameyers2]

The Date Parse feature in Power Query is very limited. It doesn't support many common date formats, like "Apr 84" or "2014-03-10". It would be great if Date Parse would automatically handle many common date formats. Today it is difficult to extract dates from text columns like this.

[paulasturla]

Yes! Must be like "Text to column" in Excel. You can choose date formats like MDY, DMY, etc

[johnschram]

The Date.FromText () format is a good start but even it is limited to Microsoft's narrow definition of a locale format. I have attempted to use a custom pattern ('MM/dd/yyyy') like the documentation suggests, but the method is simply not robust enough. Excel, BI, and Power Query all need this enhancement.

[fbcideas_migusr]

in modelling we have different formats..it will be very helpful if we have this options in query too...