I'm using an SQL table and comparing a date column which was imported from a log file. The date is setup as a varchar not a number. I would it so that the varchar date in the column can be compared with the current date (which of course is a number) using dateformat.
The code I have is: <cfquery name="getsomedata" datasource="application_log"> select * from application2 where col002 = #dateformat(now(),'MM/DD/YY')# </cfquery> This of course does not work. What can I code in the "where col002" section that compares the varchar date (which is written 04/03/03) with the current date using the CF dateformat command? Thanks! Robert O. HWW ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
