I need a formula that will allow me to select customer who have birthdays coming in the next XX days. This would normally be easy to do but I have two issues:
1) The date field in my DB is stored in a numeric field as MMDDYY (where January 24, 1983 would be stored as 12483);
2) How do I account for year end (ie, if I run the report in December for birthdays in the next 60 days, how will it know to pull January and February birthdays?)
I have been struggling with this for some time now and I really hope someone can offer a solution. Thank you in advance for your help!
1) The date field in my DB is stored in a numeric field as MMDDYY (where January 24, 1983 would be stored as 12483);
2) How do I account for year end (ie, if I run the report in December for birthdays in the next 60 days, how will it know to pull January and February birthdays?)
I have been struggling with this for some time now and I really hope someone can offer a solution. Thank you in advance for your help!