Hi, I have a simple sql query. It takes the servers date and searches the database based on that date. The code is below:
sql = "SELECT * FROM Job WHERE JobDuration_Id = 1 AND JobStatus_Id = 2 AND PublishEndDate >=#"& date &"#"
This code has been working for over a month. Today it does not work. I have done some error checking (english dates) and the code does not work for the dates 10/09/2009, 11/09/2009 and 12/09/2009. The works for dates after and before those in the above list. Do you know any reason why they do not work?
Thanks.
sql = "SELECT * FROM Job WHERE JobDuration_Id = 1 AND JobStatus_Id = 2 AND PublishEndDate >=#"& date &"#"
This code has been working for over a month. Today it does not work. I have done some error checking (english dates) and the code does not work for the dates 10/09/2009, 11/09/2009 and 12/09/2009. The works for dates after and before those in the above list. Do you know any reason why they do not work?
Thanks.