Aimee Miller 3 Posted October 1, 2013 Share Posted October 1, 2013 Hi! I need help editing the sql statement of my spotfire query. I want to always pull Today()-1 AND Today()-2, I don't know how to write that in code. There will be multiple people using the final analysis and because of the way our production dates are stored, I do not want to use date prompts. Here is a sample of what my sql looks like at this point, with a specific date defined in the filter. Thanks in advance for any help with this! Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted October 2, 2013 Share Posted October 2, 2013 Thank you JJ! I had to modify it a little to get it to work in our system, but that was what I needed! Link to comment Share on other sites More sharing options...
JJ Burnam Posted October 23, 2015 Share Posted October 23, 2015 I might try this: AND T1."DAILY_RDG_DATE" BETWEEN (GETDATE()-1) AND (GETDATE()-2) Link to comment Share on other sites More sharing options...
Julie Sebby Posted June 22, 2020 Share Posted June 22, 2020 What was your final solution Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now