Power Query Custom Date Formats

A

asjones987

New member
Joined
Feb 7, 2020
Messages
14
Reaction score
0
Points
0
Excel Version(s)
2019
I know Power Query is not really to be used for format of date formats, but in looking at a few things it would make my life so much easier if I could have a custom date format.

I have run into several cases where i needed a date format of mm/dd/yyyy (not m/d/yyyy) or I needed dd-mmm-yyyy. I know I can format after the fact, but would rather do it in Power Query the same way you select other formats from a list or custom format creation.

This is primarily Power Query in Excel not Power BI.

Any thoughts or ideas on this?

thanks

Alan
 
In Power Query only the data type: integer, decimal, date, time, text, ... is determined. The display format is then assigned in the Excel table.
 
But then it is text and it's not so easy, to calculate with it!
 
But then it is text and it's not so easy, to calculate with it!
Click to expand...

This is a true statement. The only option then is to format the dates in Native Excel which you alluded to in your previous post.
 
thanks for the responses that is kind of what i was thinking ... in some cases the Date.ToText option may actually work for me, but I hate having to make a new column then remove the old one. Any tricks for doing it all in place?

thanks again

Alan
 
If I am honest, I must confess that I do not understand your problem. If the result of a power query contains a date, you can format it in Excel as you like. You only have to do this once, because when you update the query, the formatting is preserved. Within the Power Query a date is always shown according to the country setting. I don't need any other format, because this is not the presentation view.

However, you can also format a date in any text format within the Power Query. But what should this be good for?

You might be able to explain in more detail what you want to achieve and why.
 
You must log in or register to reply here.
Back
Top