on 09-28-2020 7:44 PM
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
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.