Macros and Programming


CardboxForumsMacros and Programming > "making a birthday calender"

making a birthday calender

How can I make a birthday calender

Posted By Post


6-Oct-2005 08:33

I cannot get my head around it

I have a database with
names and days of birth (among other things)
and i want to transform it into a birthday calender.
(so that i hav a list of people sorted by day of birth without the year)

I seem to be missing the obious (I hope)

Charles Welling

7-Nov-2005 09:10

I'm sorry I didn't answer your question sooner, but I somehow failed to notice it. You've already given the solution yourself: a list of people sorted by day WITHOUT the year. If you create another field in your database, e.g. YEAR, you can seperate the years from the months and days. If your dates have been entered consistently, you can use Batch Edit to do this for you in a few seconds. The "month and day" field should be in that order: first the month, then the day. If not, use Batch Edit again to change this.

A simple sort on month and day will create your birthday calendar. You could use the seperate YEAR field to print something like "Born in: xxxx", so that people can hoist a flag when someone reaches 50 or any other memorable age.

© 2010 Cardbox Software Limited   Home