#1
|
|||
|
|||
Need to change date format in power query
Hi All
I need to change the date format to dd-MMM-yy from the given dates please refer the screen shot shown below. Can anyone advise is this possible in excel power query editor? Thanks |
#2
|
|||
|
|||
Are you converting time to text string where the date is displayed in format "dd-mm-yyyy" in your query, and now you want to convert to string where date is displayed in format "dd-mmm-yy"? Or must the date returned by query be a real date, and must only be displayed differently?
In excel, a date is really an integer (an number of days between this date and start of year 1900 (there are some issues with dates less than 01.02.1900 because MS did some mistake when they started with Office), and formats you see in workbooks/tables change their appearance only. So depending on type of field your query returns, you either a) use a formula to change the datestring field in query; b) leave the query as it is and format the column in workbook differently. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculate age in power query as of a given date | Marcia | Excel | 1 | 11-12-2020 07:14 AM |
Format numbers in Power Query | Marcia | Excel | 2 | 09-21-2020 12:59 AM |
Change Date Format in Gantt Chart | culverjack | Visio | 2 | 11-08-2016 08:12 AM |
Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
MS Query date format | remigio | Word | 3 | 08-21-2012 10:54 PM |