Skip to Content
author's profile photo Former Member
Former Member

Past 3 months not visited we want these

HI - I have a Billing date; which is a String len of 10.

and I need to filter on the MAXIMUM

I have


@BillingDate =

if isdate({Vouchers.Billing_Date}) AND Date({Vouchers.Billing_Date}) > date(2014,04,01) then


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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 13, 2016 at 05:07 PM

    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)


    Maximum({@billing date}, {group field}) > DateAdd('m', -3, currentdate)


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.