on 07-13-2016 5:35 PM
HI - I have a Billing date; which is a String len of 10.
and I need to filter on the MAXIMUM
I have
Maximum({@BillingDate},{@PatientGrp})
@BillingDate =
if isdate({Vouchers.Billing_Date}) AND Date({Vouchers.Billing_Date}) > date(2014,04,01) then
Date({Vouchers.Billing_Date})
I need to report on Patients who had been in the medical center within past 2 years but have not been in 3 months. These are specially sick patients who need to see the Doctor on such timely basis. We will use this list to alert them.
I am not sure how to stipulate in @Billingdate that we want to filter those not here for past 3 months.
Hi Paul,
Frst modify the BillingDate formula so that you see correct billing dates:
If isdate({Billing date}) then
Date({billing date })
Select Default Values for Nulls from the dropdown on the top as well.
Next, add a suppression formula on the group footer with this code:
Maximum({@billing date}, {group field}) < DateAdd('yyyy', -2, currentdate)
OR
Maximum({@billing date}, {group field}) > DateAdd('m', -3, currentdate)
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.