Using SQL Editor to limit incoming data for previous year

[valeriemattas]

Hi All,

I'm trying to limit the input from a direct connection to Lawson Oracle OCI database to pull only the previous 400 days of data into my workflow. 

I am able to update my WHERE clause for a static date (such as 'WHERE CREATE_DATE >= 01-JAN-2019'), but need help with the query to dynamically filter based on 400 days from current date. 

Help! Thank you,

Valerie 

[AbhilashR · Accepted solution]

Hi Valeri, could you try using WHERE CREATE_DATE >= SYSDATE - 400 ?

[valeriemattas]

@AbhilashR Thank you! That worked.