yes, the best solution is to store the date and time in separate fields if you are able to do so. you would then use the createodbcdate and createodbctime functions for your inserts. your sql statement would read: "select * from classes where classdate in (select classdate from classes where id = #form.classsel#).
----- Original Message ----- From: Bruce Holm To: CF-Talk Sent: Wednesday, February 06, 2002 5:31 PM Subject: Re: Formatting a Date in MS SQL Access Query...Try Again 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 > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
