Forum Discussion
Date formatting
Hi, I have a table (data) like this: I want to use first row as headers. But before that I want to change the date formats in that row as text as it looks (yyyy-mm-dd). It there an easy w...
HI Anonymous
In the Power Query Editor, convert this as data column and split the columns to month, date and Year and rearrange as Year,month and date.
Then select these 3 columns and right click -> select merge option.
Promote the first row to header, the format will be retained.
Thanks
Raj
mahoneypat
Microsoft Employee
Microsoft EmployeeJust convert those columns to text before you promote headers (remove any existing Changed Type steps that convert them to Date type). This assumes your original data is in the desired format.
Pat
mahoneypat thanks for your reply, the the format is automatically changed as below (MM/DD/YYYY):
i still nead YYYY-MM-DD