Have a value fall off a report after a certain amount of days

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP


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





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











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.

Popular posts from this blog

Makefile test if variable is not empty

Will Oldham

'Series' object is not callable Error / Statsmodels illegal variable name