query date from odbc

Hi

 

 

What is the statement you're currently using and what is the error message?

 

 

David

Hi David,

 

 

I've tried many statements and different transformers so I don't have one error message I can show you since I'm still pretty new at FME and not sure where to put the statement (once I figure it out). What I was trying to do a query on my table (named lwmain) and I have a field/attribute with date and time in it (named dtrepor) and only geocode the new records- I have the rest of the transformers I need working to get the correct writer.

 

 

Thanks.

 

 

Alice

Presuming that this query is the starting point for your workbench I would use an sql creator with a query along the lines of

 

 

Select * from lwmain where dtrepor > sysdate -1

Thanks E.Gomm- That was exactly what I was looking for and it worked like a charm.