Thread: Need to change date format in power query
View Single Post
 
Old 09-15-2021, 10:32 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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