Thanks for replying. My solution ended up being using a LIKE statement. The user enters a date to query on and my code simply says - SELECT * FROM change WHERE DateEntered LIKE '%%%DateEntered%%%' AND WorkCompDate Is Null AND "Completed?" = No AND ApprovedBy Is Null AND RejectedDate Is...
I am using the Database Region Wizard to run a query on a table in an Access database. The table field I must query off in Access is a Date/Time field in Short Date format (3/12/99). Unfortunately, the FrontPage text box I created needs to send a date formatted result to the asp script to run...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.