A Date Sorting Question

[kentwoodjean]

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.

 

[PaulBricker]

Put two expression in your query. The first would be
myMonth:Month([DateField]), then myDayay([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

 

[randysmid]

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