Having trouble with building an SQL statement on the fly.

[ToyFox]

I am building an sql statement on the fly...
I am getting the following error....
Syntax error (missing operator) in query expression 'Task_Received = 2/3/2009 12:01:39 PM'.

sSQL = "SELECT Task_Information.* FROM Task_Information WHERE Task_Received = " & Me.txtReceived


Task_Received is a date/time field. Me.txtReceived is on the form. What am I doing wrong.

 

[ToyFox]

I got it...I needed the "#"..

 

[Remou]

It is usually best to format dates yyyy/mm/dd or yyyy-mm-dd to prevent locale problems.

http://lessthandot.com