Hello I am new to FME and I am trying to bring in spatial data from SQL server by adding where clause in the reader using function "SQL to Run before Read". I am not sure what query do I use?I am using the following statement but it is giving error.
select * from SDEDBO.Services where Date>=Dateadd('day', GETDATE(),-30)
thanks for your help!
Best answer by david_r
You should probably use the "WHERE clause" setting and not the "SQL to Run before Read":
You should probably use the "WHERE clause" setting and not the "SQL to Run before Read":
Looks the syntax for the Dateadd function is wrong. Check here: DATEADD (Transact-SQL)
I think the WHERE clause should be:
Date >= Dateadd(dd, -30, GETDATE())Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
