Date/Time with SQL

[vandy125]

I have two two strings that I have built into the dd/mm/yyyy hh:mm:ss format from Form input. I am trying to run an SQL query like this:
SELECT * FROM Table WHERE LastModifiedDate BETWEEN string1 AND string2;
I get syntax error when I run this. Any suggestions on how to do it?

 

[jebry]

Hi!

String1 and string2 need to be enclosed in #'s.

hth
Jeff Bridgham