Hi, I'm working with DevStudio 7703. I have developed a Excel report for a customer but when they go to sort the DateTime field it wants to sort from "A to Z". I need it to sort from "oldest to newest" or "newest to oldest". I've tried several different formats (i.e HYYMDSA, HMDYIB and it's stored as HYYMDs) but none of these are being interpreted as numeric when the customer tries sorting in Excel. Many thanks in advance if your able to assist.

This message has been edited. Last edited by: Kerry,

Hi Denny,

From our technicals: if you have not done so, please open a case with Customer Support Services and provide an example of what you are trying to do, so that we can further help. To open a case, you may call 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry