General information
Category:
Coding, syntax & commands
Hi Jos,
>just ORDER BY MyTable.HiredDate would order in correct chronological order
>Year-Month-Day. Or have I misunderstood the question?
Not quite what I need. Say you want to send a Hired Date Anniversary card to each person who was hired during the Month of July no matter what year, and you want them printed out for your secretary in Month-Day order.
>Another option could be:
>SELECT Fld1, Fld2, FldX, MONTH( HiredDate ) AS nMonth, DAY( HiredDate ) AS
>nDAY FROM MyTable ORDER BY nMonth, nDay<
>
Yep... that did the trick. Thanks a million.
Mel Cummings
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only