looking for a fool proof method of converting date to age

looking for a fool proof method of converting date to age. BUT the input field must allow the user to either type the age or the date.

in other words if they type an age do nothing just save

if they type a date convert to age

if they type something else fix their error
kleighAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jyokumCommented:
> if they type something else fix their error
that's a pretty tall order. what if I type in "goober"? there's no way I could figure out what the person really meant.

this will at least handle the date or age... it will just display an error for anything else


<cfif isDefined('form.ageORdob')>
      <cfscript>
      error=0;
      if(IsDate(form.ageORdob) AND DateCompare(form.ageORdob,now()) lte 0) age = DateDiff('yyyy',form.ageORdob,now());
      else if(IsNumeric(form.ageORdob) and form.ageORdob gte 0) age = form.ageORdob;
      else error=1;
      </cfscript>
      <cfoutput>
      <cfif error>
      <p>The value you supplied (#form.ageORdob#) is invalid. Age must be a positive number or a valid date that does not occur in the future</p>
      <cfelse>
      <p>According to the value you supplied (#form.ageORdob#), you are #age# years old</p>
      </cfif>
      </cfoutput>
</cfif>

<form name="frmData" method="post">
Enter your age or birthdate: <input type="text" name="ageORdob"><br />
<input type="submit">
</form>

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
anandkpCommented:
a option shld be given to the user to decide whether he wnats to input [age] OR [dob]

what i do is - get the dob from the user & calculate the age.
but if u think users dont wanna reveal their "full dob" - then u cld ask them to just enter "dd/mm" & let them enter age in a seperate input box

this way they decide how old they wanna appear on ur site & also give in their dob [depends if ur site uses it]

else there wld be seveeral workarounds - to chk for the numeric field & make sure user dosent type in something else ... but they all wont look elegant. id suggest a  change in flow [if u can - pls do it]

rest its ur call ...

let us know incase u need more help !

K'Rgds
Anand
hartCommented:
to avoid all these checks...

give three drop downs in the form..
one for days, months and years..

now let the user select the day/month and year..

and all u have to do is calculate the age by using datediff function..

Regards
Hart
Tacobell777Commented:
This will do what you want, it's not how I would handle it, but.......

<input type="text" name="age">

<!--- try and get the age from a date --->
<cftry>
      <cfset age = dateDiff("yyyy", form.age, now())>
      <!--- the value passed was not a valid date --->
      <cfcatch>
            <!--- see if an integer was entered --->
            <cfif val(form.age) NEQ 0>
                  <cfset age = form.age>
            <cfelse>
                  Sorry not a valid date or age.
            </cfif>
      </cfcatch>
</cftry>
<cfoutput>
#variables.age#
</cfoutput>
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.