Comparing different date fields for multiple record types.

Question

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 ideas on approaches to handle that?

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

markshnier__you · Answer

Do you have any relationships? &nbsp;What are your tables and how're they related?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

jeromemitchell · Answer

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

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

Below is a sample report that shows specific survey records for a site. These different surveys have a original survey date and survey type.&nbsp; 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.&nbsp;&nbsp;Now I know the records below don't show one, but for example, the 1-10-20 complaint survey has a revisit date of&nbsp; 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&nbsp;revisit".&nbsp;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 · Answer

This would probably need some one on one assistance to see if it's possible.&nbsp; 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Comparing different date fields for multiple record types.