Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

A Date Sorting Question

Status
Not open for further replies.

kentwoodjean

Technical User
Oct 19, 2002
376
US
Trying to figure out how to format a parameter on a query having to do with senority dates. Date formated as mm/dd/yr. To determine overall senority, this full date is fine. Certain rotating assignments are given based on MM/DD only. What should my parameter look like in order to just sort by MM/DD? It is probably very simple, but cannot find the answer in my reference material.
 
Put two expression in your query. The first would be
myMonth:Month([DateField]), then myDay:Day([DateField])
The set the sort for these two field Ascending. Make sure the Month field is to the left of the Day field so the Month gets sorted first.

Paul
 
Hi,
There may be a problem with this solution. You will end up with data looking like this:
John Doe 01/01 (1999)
Mary Adams 01/01 (2002)
Amy Tan 01/03 (2000)
Doug Wu 01/05 (1985)
Fred Lee 01/07 (2001)

Now, maybe this is ok if you are getting birthdates, but is this appropriate for seniority dates? Just wondering!!
HTH,
Randy Smith
California Teachers Association
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top