Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Date format

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-28 : 23:58:35
Dan Noble writes "My query statement is

dbTable = "W_12617"
sDate = FormatDateTime("1/25/2001", 0)
Query = "Select * FROM " & dbTable
Query = Query & " WHERE FM_CHGDATE = #" & sDate & "#"

I'm getting an "Missing Operand" error. Any clues?? THANKS for your time.

Dan Noble dnoble@i3-group.com

PS. this is a FoxPro Table, but I'm really in a jam"
   

- Advertisement -