Bill,
Try the Format function - Format(date value, "dd/mm")
Glenn
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Singer
Sent: Wednesday, July 3, 2013 12:55 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Date format sorting
I am wondering if there is any way to create a date format like the
following.. mm/dd ?
I work at an insurance agency and the policies renew on January 1st or
February 1st.. etc. I do not need the year, and I actually do not want
the year because it gets out dated as each year passes.
I am also hoping to be able to sort by this field as well, in chronological
order. For example 03/01 would come before 12/01.
Any assistance you could provide would be great.
Bill Singer
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar