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" <[EMAIL PROTECTED]> wrote in message
024601c11073$1f9645f0$bd08eb84@jasper">news:024601c11073$1f9645f0$bd08eb84@jasper...
> I'm used to Oracle, so I always choke on Access stuff . . .
> How do you do a NOT BETWEEN in Access?
> (Note: StartTime is a Date/Time Field)
>
> EX:
> SELECT StartTime
> FROM myTalbe
> WHERE StartTime NOT BETWEEN 1899-12-30 18:00:00 AND 1899-12-30
> 18:30:00
> ORDER BY StartTime
>
> Thanks,
> Dave
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
