Skip to Content
0
Sep 28, 2020 at 06:44 PM

To extract the data for last 30 days via SQL query in redwood filter

95 Views

Hello Experts,

Need help in the below query to extract the data for last 30 days from current date in redwood using SQL 92.

The below query is not working. kindly help.

Select * from JobDefinition jd,JobChain jc where jd.BranchedLLPVersion = -1 and jc.JobDefiniton = jd.UniqueId and jc.LastModificationTime >now()-30

Thanks

Gabie