Need to sort date field (yyyy, mm, dd) by mm, then dd -- can't figure 1

[BetteBoop]

Have Crystal 6.1.4, using SQL server. Creating report to display birthdate, but not include year. Need to sort by mm, then dd. In db, Birthdate field defined as Date (yyyy, mm, dd).

Thanks for your help.

 

[kenhamady]

Create the following formula and sort on it:

Month({birthdate}) * 100 +
Day ({birthdate})


This will turn 12/01/76 into the number 1201, which will sort as you described.


Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)