HI, I would like my data format to turn out to be "MM/DD/YYYY" or "DD/MM/YYYY" however when it is loaded into power query, it turns out as follows
The first data should be June 1st 2019. The last two digits from right should be year "2019" . should I use the Extract function to extract the right two digits and make a custom column for year, then extract middle section and so forth? But since all my data are like this is there a way to create a new data function for this type that I can use repeatedly when this format comes in?
Hi Junko,
You could use the Text.Start, Text.Middle and Text.End functions to extract the date elements and then join them back together as a date. You can see the different Power Query text functions here.
You can then copy this formula as required.
Mynda
HI thanks for your tip. I was able to customize the date. (attachment 1) Nevertheless, is there a way to make this a function? so I can apply this to other dates that require date change. (i.e. credit date, delivery date etc)
Well you can (see the session 7 on custom functions), but functions aren't really any more transferable from one query to the next than the custom column formula. I'd just save the formula in a text file for use in other queries.
Mynda
