Joined: 31 Mar 2009
Online Status: Offline
Posts: 1
Topic: Birthday search ignoring the year Posted: 31 Mar 2009 at 1:01am
I have a database where I capture the customers date of birth.
What I require is a formula to be able to put in a date range (say from date to date) and for Crystal to return any birthdays that fall in that date range Ignoring the year parts!
So if I search for 01/01/2008 to 01/03/2008 it will return ANYONE who has a birthday in January or February.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 31 Mar 2009 at 6:18am
Well, this seems challenging. I am guessing that you are going straight to the tables, not via a stored proc, so this would be a filter on the records. With that said, I would guess that your filter look something like:
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
