Data Input from OLEdb : Previous 4 Weeks Data Pull

Question

For my workflow, I have 5 OLEdb tables that I'm pulling data from, and due to the size of the data, I filter for the previous four weeks based on the 'Criteria' in the data input. Currently, I built an app where I enter the date in the 'YYYY-mm-dd' format, and it updates the date filter on the OLEdb data input for all 5 tables. I would like this to automatically run in server every week and always pull the previous 4 weeks. Is there a way to update the 'Criteria' in the OLEdb data input to always pull from the previous 4 weeks, rather than have to manually enter the date utilizing the app?

amckinney · Answer

Unfortunately, that did not work. I kept getting an error that SYSDATE was not a field. I did try a DateAdd function and that appears to be working.

cjaneczko · Answer

Can you use the below?

Select * From "TABLE NAME" Where "DATE COLUMN" >= (SYSDATE -28) AND "DATE COLUMN" < SYSDATE