ETL and Data Integration tools - Modern ETL software for everyone

Hello

We are trying to use the filter feature within VI so that when extracting records for the Source part of our job, it only extracts a certain list of records. We want to write a query that will only extract (as the source) records that are no more than 25 days old. We based this on a datefield (lets call it “DateField”). Our Pseudo code would look something like

Select * from TableXX where TableXX.DateField > (CurrentDate – 25)

We looked at your date functions but can’t seem to get any of them to work the way we want. Do you have any ideas/suggestion on how to accomplish this?

George

What is you datasource?

Peter

FOXPRO