> Thanks Rich. Tried to implement but recevd errors with Convert. Where does > this command go pls? In the where? Tried that but still got errors.
As Janet noted, that syntax is for MSSQL. I did a quick test in Access, and you can get similar results using the following: WHERE Format(myDate, 'mm/dd/yyyy') = '03/26/2005'; HTH, Rich Kroll > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273766 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
