Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-15-2021, 12:10 AM
ganesang ganesang is offline Need to change date format in power query Windows XP Need to change date format in power query Office 2016
Competent Performer
Need to change date format in power query
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default 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
Attached Images
File Type: jpg Date.JPG (37.4 KB, 6 views)
Reply With Quote
  #2  
Old 09-15-2021, 10:32 PM
ArviLaanemets ArviLaanemets is offline Need to change date format in power query Windows 8 Need to change date format in power query Office 2016
Expert
 
Join Date: May 2017
Posts: 640
ArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of light
Default

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.
Reply With Quote
Reply

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
Need to change date format in power query Format numbers in Power Query Marcia Excel 2 09-21-2020 12:59 AM
Need to change date format in power query 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
Need to change date format in power query MS Query date format remigio Word 3 08-21-2012 10:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft