3 Replies Latest reply on May 20, 2012 11:05 PM by Dimitri.B

    Show the first ever date for a patient, filtered

    Neal Smoller

      So I have a pharmacy.

       

      Transactions in our table look like this:

       

      Patient Name, Rx Number, Fill Date, Blah Blah Blah

      Patient Name, Rx Number, Fill Date, Blah Blah Blah

      Patient Name, Rx Number, Fill Date, Blah Blah Blah

      Patient Name, Rx Number, Fill Date, Blah Blah Blah

       

      I would like to see a list of patients who filled their first ever prescription with us this past week.

       

      I've got a list of patients and their first fill date.

       

      How do i filter this down successfully?