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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4