I currently run a report that returns customer birthdays within given date perameters. I use the following formula to calculate birthdays: Date(year(CurrentDate),month({driver_details.drd_dob}), day({driver_details.drd_dob})
) I then set parameter values to return birthdays within a certain range (e.g. start 22/12/2008 end 28/12/2008). This has been working perfectly until I try to go into 2009, (e.g. the report for 29/12/2008 to 04/01/2009) only returns birthdays up to 31st Dec. Do you have any suggestions as to how I could modify my current formula or make a new one that will give me birthdays into next year? Any advice you have would be much appreciated!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: