Date Searching MS Access database

[Anon]

Hi, Im wondering if anyone has written code for searching through an access database based on a from and to date fields

The timestamp on the access database is in the format

yyyy-mm-dd hh:mm:ss

so I make $datefrom and $dateto the same format.

I have a form which ask for the date and convert it to this format, but in the php statement the 'where timestamp is < $dateto and > $datefrom'

but i get a Syntax error (missing operator) in query expression

any ideas ? thanks

[Anon]

where timestamp < $dateto
and timestamp > $datefrom

You're problem is in the sql syntax. I'm not an access guy so I just wrote it above in ANSI sql.

In ANSI standard sql the IS operator is only used for IS NULL or IS NOT NULL, and you always have to have an operator on each side of an expression (just like basic math).