on 06 Apr 2016 01:16:04
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.
- Comments (3)
RE: Support many date formats in Power Query Date Parse
in modelling we have different formats..it will be very helpful if we have this options in query too...
RE: Support many date formats in Power Query Date Parse
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.
RE: Support many date formats in Power Query Date Parse
Yes! Must be like "Text to column" in Excel. You can choose date formats like MDY, DMY, etc