Age and Birthday

  • Thread starter Thread starter Phil Hunt
  • Start date Start date
P

Phil Hunt

Hi,
Any quickie function to find out the birthday, given the age ?
btw, first time to cross post, hope i did it right

Thanks
 
Any quickie function to find out the birthday, given the age ?
btw, first time to cross post, hope i did it right
Click to expand...

??? If I told you my age you'd have a 1 in 365 chance of guessing my
birthday. Now granted, your chance of guessing my birth YEAR is 1 in 2....

I think you need to be more specific.
 
if you tell someone you are between 25 and 30, what are all the possible
birthday (mm/dd/yyy) you could be born on
 
Phil Hunt said:
if you tell someone you are between 25 and 30, what are all the possible
birthday (mm/dd/yyy) you could be born on
Click to expand...

What book is that from? Can anyone imagine a real life
need for such a function? ;-)

LFS
 
Could be used in filling out a survey where the approximate
age is requested, as is the approximate salary (ranges).

Saga
 
Saga said:
Could be used in filling out a survey where the approximate
age is requested, as is the approximate salary (ranges).
Click to expand...


What survey would want each and every date listed that
falls between two dates. More than likely the survey would
accept and *store* the two dates... :-P

LFS
 
you are getting there.
Larry Serflaten said:
What survey would want each and every date listed that
falls between two dates. More than likely the survey would
accept and *store* the two dates... :-P

LFS
Click to expand...
 
Phil Hunt said:
you are getting there.
Click to expand...


Why are you being so elusive? If you want a definitive answer, then you need
to ask a definitive question. You're just beating around the bush.

Mike
 
Phil Hunt said:
if you tell someone you are between 25 and 30, what are all the possible
birthday (mm/dd/yyy) you could be born on
Click to expand...

Are 25 and 30 inclusive? If so, then there are 6 years involved. 365 (days
in a year) * 6 (number of years) = 2190 possible dates (of course, that
doesn't take leap years into account). I take it you don't want the number
though. You want the actual dates. That's more complicated. Are you going
to start with Jan 1st ~6 years ago? Are you going to start from whatever
date is exactly 6 years earlier than the current date? Are you going to go
until Dec 31 of the current year? Are you going to go only up to the
current date (IOW, disallow future birthdays for the current year)?

You need to elaborate on exactly what you need and possibly even the
purpose. I can't imagine any reason for needing to calculate EVERY date
within a given range. More curiosity than anything, but what on earth are
you planning to do with all of these dates once you've determined them?

Mike
 
Are 25 and 30 inclusive? If so, then there are 6 years involved. 365 (days
in a year) * 6 (number of years) = 2190 possible dates (of course, that
doesn't take leap years into account). I take it you don't want the number
though. You want the actual dates. That's more complicated. Are you going
to start with Jan 1st ~6 years ago? Are you going to start from whatever
date is exactly 6 years earlier than the current date? Are you going to go
until Dec 31 of the current year? Are you going to go only up to the
current date (IOW, disallow future birthdays for the current year)?

You need to elaborate on exactly what you need and possibly even the
purpose. I can't imagine any reason for needing to calculate EVERY date
within a given range. More curiosity than anything, but what on earth are
you planning to do with all of these dates once you've determined them?

Mike
Click to expand...

Give the User a list of all possible b'dates so he/she can pick the real one...
<BeG>

Have a good day...

Don
 
I am not trying to be elusive. You only get that feeling from jumping into
middle of the conversation. My situation is this: i have a lot of people on
the DB with their birthday, and I want to find them by asking "where Age is
between 25 and 35"
Anyway, i was just being lazy to ask. I later found out I can use
DateAdd("YYYY",-25,Date) and DateAdd("YYYY",+35,Date). Now can you concur
with with ?
 
if you tell someone you are between 25 and 30, what are all the
possible
Give the User a list of all possible b'dates so he/she can pick the real one...
<BeG>
Click to expand...

Yep, I can see a paraphrase of that program now...

Program: "How old are you?"
User: "Somewhere between 25 and 30 years old"
Program: "Okay, here's a list of 2190 possible days
for your birthday, please select one"
User: "Hmm! Let's see now...."

Rick
 
Phil Hunt said:
I am not trying to be elusive.
Click to expand...

Maybe not, but that's the result.
You only get that feeling from jumping
into middle of the conversation.
Click to expand...

I saw what looked like an initial post and read from there on and still
think the question has been unecessarily vague.
My situation is this: i have a lot
of people on the DB with their birthday, and I want to find them by
asking "where Age is between 25 and 35"
Anyway, i was just being lazy to ask. I later found out I can use
DateAdd("YYYY",-25,Date) and DateAdd("YYYY",+35,Date).
Click to expand...

You need to get anybody who turns 25 today through anybody who turns 36
tomorrow; DateAdd will do it but what you have there is not correct.
Now can you concur with with ?
Click to expand...

Huh?
 
I am not trying to be elusive. You only get that feeling from jumping into
middle of the conversation. My situation is this: i have a lot of people on
the DB with their birthday, and I want to find them by asking "where Age is
between 25 and 35"
Click to expand...

And HOW IN THE WORLD were we supposed to figure that out from your initial
question, which I'll repeat here:

Next time you work on a project and you're gathering requirements from your
users and you have to virtually pull teeth to get information out of them,
maybe you'll understand what it's like for us and try to be more clear the
next time you post a question in a newsgroup.
 
I thought that what programmer do, make sense out of some vague questions
that the user asked.
 
I thought that what programmer do, make sense out of some vague questions
that the user asked.
Click to expand...

We very often do. And, having felt the pain, we try not to do it TO EACH
OTHER.
 
Back
Top