M mynndd Guest Aug 7, 2001 #1 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.
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.
W willsaunders Registered User. Local time Today, 11:10 Joined Aug 8, 2001 Messages 18 Aug 9, 2001 #2 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.
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.
