[wdvltalk] Re: ASP posts - Age range in SQL query
I resemble that description. I know just enough to be dangerous and do not consider myself to be a programmer. Cheryl D. Wise Microsoft MVP WiserWays, LLC 713 353-0139 www.wiserways.com mailto:[EMAIL PROTECTED] -Original Message- From: rudy think about that for a second not everybody who uses access is a vb programmer The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: ASP posts - Age range in SQL query
> Great question Rudy! I wondered the same thing and stumbled across this > function that is native to Access. stumbled, how? it sure isn't in the access 2000 help file, is it "native to access" -- it is to laugh > (StrConv([text1],3)) - 3 stands for vbProperCase but Access > didn't like the verbiage so I let it be 3. that's it, right on the money > Let me know how this works for you! oh, i'd already found it, after a half hour on google one day last week i just thought it was a simple problem, and wanted to see if anybody else could find the answer without pulling their figgin hair out no fair looking in a vb reference, not everybody who uses access is a vb programmer think about that for a second not everybody who uses access is a vb programmer rudy The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: ASP posts - Age range in SQL query
rudy wrote: where year(date()) - year(DOBfield) - iif(month(date()) > month(DOBfield),0, iif(month(date()) < month(DOBfield),1, iif(day(date()) < day(DOBfield),1,0))) between 30 and 40 Tim: Dang, rudy, you did it to me again - I didn't know SQL supported an "iif"! Just like VB. :-) Now I've got about 100 stored procedures to go rewrite... Tim The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: ASP posts - Age range in SQL query
> SELECT * FROM myTable
> WHERE ((DateDiff('',DOBfield,DATE())
> BETWEEN 30 AND 40))
clancy, try this:
where year(date()) - year(DOBfield)
- iif(month(date()) > month(DOBfield),0,
iif(month(date()) < month(DOBfield),1,
iif(day(date()) < day(DOBfield),1,0)))
between 30 and 40
this is accurate, including right on the person's birthday
rudy
• The WDVL Discussion List from WDVL.COM •
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
http://www.wdvl.com ___
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
