RE: (OT) Access SQL Statement

2001-07-20 Thread Mark Warrick
-Original Message- From: Skyward Internet Technology [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 12:05 PM To: CF-Talk Subject: Re: (OT) Access SQL Statement A dump of the PriSched table reveals that STime and ETime look like such: 1899-12-30 06:00:00 1899-12-30

Re: (OT) Access SQL Statement

2001-07-20 Thread Skyward Internet Technology
T STime BETWEEN 1899-12-30 21:00'. Thanks, Dave - Original Message - From: "Mark Warrick" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, July 20, 2001 12:38 PM Subject: RE: (OT) Access SQL Statement > > >

RE: (OT) Access SQL Statement

2001-07-20 Thread Mark Warrick
= Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric ==

Re: (OT) Access SQL Statement

2001-07-19 Thread tom muck
Access uses the pound sign to delimit dates: SELECT StartTime FROM myTalbe WHERE StartTime NOT BETWEEN #1899-12-30 18:00:00# AND #1899-12-30 18:30:00# ORDER BY StartTime You'll probably have to double them up to use the query in CF. tom "Skyward Internet Technology" <[