Haha, yeah day not year =)
Was too early to be helping.
Tyler Clendenin
GSL Solutions
-Original Message-
From: Tyler (T2) Clendenin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 01, 2005 9:35 AM
To: CF-Talk
Subject: RE: Correct Way To Query For Birthdays
Why not use
WHERE Month(DOB) = Month(GetDate) AND Year(DOB) = Year(GetDate())
Tyler Clendenin
GSL Solutions
-Original Message-
From: Claremont, Timothy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 01, 2005 9:20 AM
To: CF-Talk
Subject: Correct Way To Query For Birthdays
My field name is DOB, and I want to query the list for dates that match
today. Of course, the year will never match. I have tried a bunch of
different ways, but I know there must be a more elegant way!
BTW: CFMX and Access
TIA,
Tim
**
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please delete it from your system.
This footnote also confirms that this email message has been swept for the
presence of computer viruses.
Thank You,
Viahealth
**
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192590
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
