Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    4

    Unanswered: Create expression for Date of Birth excluding the Year

    I hope someon can tell me how to sort partial date values. I have tried to follow the help link but I get confused. I want to sort a table by the month and day of the birth but exclude the year. My expressions seem to trigger a parameter window to pop open.

    Thank you.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    It should be something like:
    Code:
    SELECT... FROM... ORDER BY Month([DOB]), Day([DOB])
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •