The problem you are having is your date in the Access table has a timestamp of 00:00:00 when you say now() that has a timestamp of the current time so you yield no results try:
The long way: <CFSET #Year# = #dateformat(now(),"yyyy")#> <CFSET #Month# = #dateformat(now(),"m")#> <cfset #daynow# = #dateformat(now(),"d")#> <cfset date=#createdate(year, month, daynow)#> <cfset date=#createODBCDateTime(date)#> At 04:20 PM 9/12/2002 -0400, you wrote: >OK I give up. I know when I am beat. This is a simple one. I know this >but I just can't get it to work for some reason. I saw something similar >in an old post, but it was not informative enough. > >Here's the deal: > >I have 2 tables in a Rock Band's database. (annie.mdb) > >GIGLIST and GIGDATES > >I have a template page that I want to show TONIGHT'S SHOW data if there >is a show tonight and IF NOT, then the NEXT SHOW date data. > >as I am sure you can tell by the extension, this is an ACCESS Database, >I have the GIGDATE field set to a "date" field. (MM/DD/YYYY) > >Fields are as follows: > >GIGLIST<Tablename> >ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE > >GIGDATES<Tablename> >ID, GIGNAME, GIGDATE, GIGTIME > (GIGNAME = giglist.name) > > > >So, let me reitterate.... I want to show all of the current variables >for the show record that has tonight's date (if there is a show tonight) >and set a variable "NEXTSHOWTIME" to either display the text "Tonight's >Show" or set to "Next Show" if no show tonight and then show the next >available showdate's recordset from the GIGDATES table and the >corresponding venue location info from the GIGLIST table. > >GIGNAME=NAME in the GIGLIST table > > > > > > > >FREE MUSIC CD to the first one who sends me code that makes this thing >work! > >Thanks! > >M. Pool >[EMAIL PROTECTED] > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
