Have a value fall off a report after a certain amount of days
Have a value fall off a report after a certain amount of days
Edited
What I'm trying to do is have customer information fall off of my report for 35 days when someone approves of it. I'm currently using the code
CASE WHEN action_code_no = '15' and result_code_no = '93' then
datediff(Day,data.date,GETDATE()-35) end <= data.date
my desired result is to get data.date back down to 0, the report is set up so that when data.date reaches 35 it populates the report and when the action code = 15 and result code = 93 I want it to subtract 35 from data.date, hope this edit helps
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Sample data and desired results would really help. It is entirely unclear what those codes have to do wth any approval.
– Gordon Linoff
16 mins ago