Skip to Main Content
PeopleHR Ideas Portal
Status Open for Voting
Categories Queries/Reporting
Created by Claire Harrison
Created on Dec 1, 2023

Improvement to Excel download from Queries

When certain numerical data is exported to Excel from Queries, it comes out as a text file e.g. length of service dates and dates/days of birth (e.g. when looking at age). This means that when you try to sort on Excel it does it alphabetical rather than chronologically. You get all the 1 months then 1 years, then 10 months then 10 years which is entirely useless.

Describe the Challenge Twice as much time is needed for what should be a simple activity
  • Attach files