Birthdate

[patnoe]

I wish to be able to send a birthday card to my active customers.____To do this, I first select a transaction table which shows they are still active, then join with my customer file which contains the birthdate. I am using a FoxPro Database for the application. ____The First PROBLEM: How do I sort the records by date so that I can print out a month of birthdays by birthdate, (Day 1, Day 2, Day 3, etc.)at a time?____Second PROBLEM: When I sort by Birthdate, the birthday does NOT show in the record line.

[kfleming]

if the birthdate field is on the record band and you are not suppressing the record band then it should print.____If you want to sort by month and day (and ignore the year) you could create two calculated fields. The first would be MONTH(birthdate) to return the month of the birthdate field (1-12) and the second would be DAY(birthdate) to return the day of the month (1-31).____Kathleen__R&R Support