On 2/6/02, Bruce Holm penned: >BTW, when I created the date in Access, I specified the Date format to be >General which stores date and time info in the SAME field.
BTW Bruce. Access always stores dates as date and time. So does SQL Server. When you choose type of date/time when creating the field, you're just telling Access how to display it when looking at the table directly. The trick is, when you insert a date with a SQL query, insert it with createodbcdate. Then the time portion of any date/time you enter, such as #createodbcdate(now())#, will be inserted as 00:00:00. Then the search using# createodbcdate(mydate)# will return that date. This way you won't need to search for a range if looking for a single date. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
