Querying Database - date/time

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

here is my sql statement:

fp_sQry="SELECT * FROM Results WHERE (Timestamp
= '::datefrom::' AND Timestamp <= '::dateto::')"
Click to expand...

this wont work but I found a fix for querying a date/time
field. They basically say that I need to
change '::dateto::' to #::dateto::# - the problem i am
having is when I change this, Frontpage will not let me
save it that way, it just changes it back, even when I try
to save in HTML mode.

How can I save the code without Frontpage overridding me
or better yet, how can I query a date/time field in a
database?

thanks
 
Back
Top