<cfinput type="text" name="xdate_use" > ex: 05/31/2012 <cfinput type="text" name="xtime" > ex: 3:31 PM
Given the values used as examples for the fields above, exactly how would I go about querying a datetime stamp field (SQL Server) to find all records dates on or after the date/time above? No problem doing it with just the date: responsedate >= <cfqueryparam value="#trim(form.xdate)#" cfsqltype="CF_SQL_DATE" /> but for the life of me, I can't figure how to put both fields together to do date AND time... I'm probably an idiot.. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
