Thanks for the response and tips. Are you suggesting I use a date and a time column in my classes db? With several classes per day, they each have a time of day. I was trying to be efficient and use a single date/time field to store this info. The trick then becomes how to find records with the same date (ignoring the time element) for all classes on any given day.
Bruce ----- Original Message ----- From: "Bud" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 06, 2002 3:08 PM Subject: Re: Formatting a Date in MS SQL Access Query...Try Again > 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 > ______________________________________________________________________ Get Your Own 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=coldfusionb 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
