incorrect syntax near keyword 'where'

jadams

When using the following where clause
WHERE Timestamp > '1/1/2008'

I receive the error "incorrect syntax near keyword 'where'"

does anybody know, is this due to the use of the keyword Timestamp as a column name? I have other where clauses working fine. I have also tried the following:
WHERE [Timestamp] > '1/1/2008'

This is a packaged app, so I don't have any control over the column names.

Any help here is greatly appreciated.

Thanks

richardjm

Just omit the word WHERE from the where clause editor and it should be fine we automatically add the WHERE whenever there is anything set in the UI.

HTH