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

Date.JPG (37.4 KB, 13 views)

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.