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 |