Reformatting dates in spreadsheets obtained from Query Builder

Modified on Tue, 18 Jan, 2022 at 8:43 AM

You can't re-format the dates in the query builder itself, but there is a way of reformatting them quickly in Excel.  

 

Select the column with the dates in, then in the Data menu click 'Text to Columns'.  Accept the first 2 pages of the wizard (no changes should be necessary), but on the 3rd page, select ‘Date’ and the format you want. The entire column will change to a date format in one go.



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article