date in a sql statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the criteria to put a data in a query. I what to have the user
select the correct date. I've tried

#[date]#
[#date#]

Please help me out.

thanks
 
Not sure what you mean. To prompt for the date, you'd do...

SELECT Employees.HireDate
FROM Employees
WHERE (((Employees.HireDate)=[enter date]));


To specify a date, you'd do...

SELECT Employees.HireDate
FROM Employees
WHERE (((Employees.HireDate)=#12/31/1999#));
 
Back
Top