We have a feature in our ECR system that allows us to pull in a sub-report into our services. This way our nurses can view past information that helps them with viewing all associated client information.
This "service" is called "Health Care Review - 30 Day". This service has a date field that is stored in our database as actual_date.
Within this "Health Care Review - 30 Day" we have a sub-report that pulls in all "Nursing Assessments".
I need to enter SQL into the sub-report that tells it to just pull in "Nursing Assessments" that occurred within the prior 30 days from the "Health Care Review -30 Day's" actual_date.
So if I created the "Health Care Review - 30 Day" with an actual_date of 3/30/2012, my sub report should pull in only the "Nursing Assessments" that occurred in the prior 30 days of the 3/30/12 "Health Care Review - 30 Day" actual_date.
So if there are any "Nursing Assessments" within 3/1/2012-3/30/2012 they will pull.
The actual_date of the "Health Care Review - 30 day" can change so it is not a concrete date. So this is why I need a formula that will just pull 30 days prior to whatever date has been entered for the actual_date.