input mask (1 Viewer)

[mynndd]

I need to know what I would use as an input mask for the medium date format 08-Sept-60 so I can sort, or info on how to sort date with the short format 01/01/01 so that it sorts by the month. Any help would be great.

 

[willsaunders]

If you just set the query to sort date ascending, (The drop down box in design grid), this should sort you out.

You can use format to always display the date as medium date. Use the drop down menu for that too instead of doing it manually.

Let me know if it helps,

Will.