RE: Correct Way To Query For Birthdays
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
Re: Correct Way To Query For Birthdays
Claremont, Timothy wrote: > 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! Others have already answered your question suitable. Let me just rant that stupid Postgres doesn't have Day() Month() and Year() functions like every other freakin' database in the world. MySQL uses DayOfMonth() and didn't add Day() until 4.1 ~| 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:192555 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
Re: Correct Way To Query For Birthdays
SELECT * FROM myTable WHERE DAY(DOB) = DAY(GetDate()) AND MONTH(DOB) = MONTH(GetDate()) HTH, Chris >>> [EMAIL PROTECTED] 02/01/05 08:19AM >>> 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:192545 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 ** ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192544 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54