all kinds of suggestions, why don't you send over some code you are currently trying, and then im sure we can fix 'er right up.
...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -----Original Message----- From: Double Down, Inc. [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:53 AM To: CF-Talk Subject: Extracting Dates From DB I have two date questions that I need some help with. First question: I need to extract a records where the member id and current date match. The date is in the SQL DB as a datetime field. I tried using the date format function in the query but could not get it to work. Second question: I am going to need to extract records from the DB where the member id and month and year are the current month and year. Can anyone suggest solutions to these problems. TIA DDINC ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4