Forum Discussion

Qrew Member

3 years ago

Comparing different date fields for multiple record types.

Issue: I'm trying to return SurveyType=Complaint records where the 1st revisit date for the complaint record is the same as the Original Survey date of a different SurveyType = Standard record. Any...

reports and charts

Tables and fields

MarkShnier__You

Qrew Champion

Do you have any relationships? What are your tables and how're they related?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Qrew Member

3 years ago

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
------------------------------

MarkShnier__You
Qrew Champion
3 years ago
I would like to try to help but I don't understand your question. Can you illustrate it with an example?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- JeromeMitchell
  Qrew Member
  3 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 1^st 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
    Qrew Champion
    3 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
    mark.shnier@gmail.com
    ------------------------------