Forum Discussion

JeromeMitchell's avatar
JeromeMitchell
Qrew Member
5 years ago

Re: Comparing different date fields for multiple record types.

All of these are in a single surveydata table tied together by facility name. So we can have many survey types by survey date per facility.

------------------------------
Jerome Mitchell
------------------------------

3 Replies

    • JeromeMitchell's avatar
      JeromeMitchell
      Qrew Member
      5 years ago
      Below is a sample report that shows specific survey records for a site. These different surveys have a original survey date and survey type.  What i want to pull are only the complaint survey type records where the 1st revisit date is equal to original survey date for the next Standard survey type record.  

      Now I know the records below don't show one, but for example, the 1-10-20 complaint survey has a revisit date of  3/5/20. If the next standard had a original survey date of 3/5/20 (instead of 1-10-20 now) I would want to return the 1-10-20 complaint record because it met the criteria I was looking for: "any complaint surveys that had their Annual as their 1st revisit". 

      I hope this explains what I am trying to do. The trick is I'm trying to compare 2 different records, and I know that is not easy in QB.

      Thanks for your help in advance.





      ------------------------------
      Jerome Mitchell
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        This would probably need some one on one assistance to see if it's possible.  There is a new ability coming called Formula Queries which would probably solve this issue, but that is not even out in Beta yet, so still months away.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        [email protected]
        ------------------------------