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

Newer than 90 days question


I have a report I am creating for a medical clinic using date and procedure code fields.

I need to find all patients who had exactly 2 injections in the same eye, but none of the injections FOR THAT EYE can be older than 90 days.

***I cannot just filter out all injections older than 90 days because if the patient has EVER had an injection in that eye before the 90 days, they need to be excluded from any results regarding that eye (even if they had an injection in that eye in the last 90 days).

Here is an example of what I need:

Patient Name Procedure Date Procedure Code Modifier field (Which Eye)

John Doe 7/1/2014 12345 Rt

John Doe 7/10/2014 12345 Rt

NOT THIS (even though patient had 2 injections in same eye in last 90 days, the OLDER injection disqualifies the patient completely)

Patient Name Procedure Date Procedure Code Modifier field (Which Eye)

John Doe 3/1/2010 12345 Rt

John Doe 7/10/2014 12345 Rt

John Doe 7/17/2014 12345 Rt

Any help would be greatly appreciated!

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 18, 2014 at 07:03 PM

    Hi,

    Try this please:

    1) Create a Group on the Patient Field. Then Create a Group on the 'Modifier Field'

    2) Go to Report > Selection Formulas > Group and use this code:

    Minimum({Procedure_Date},{Modifier}) <> Over90Days

    AND

    Count({Procedure_Code},{Modifier}) = 2

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2014 at 06:21 PM

    Abhilash,

    It worked! Thank you!


    Would it be possible to give a brief explanation behind your answer?

    Minimum({Procedure_Date},{Modifier})
    <> Over90Days

    I would like to understand this better.

    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.