cancel
Showing results for 
Search instead for 
Did you mean: 

Past 3 months not visited we want these

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

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

Answers (0)