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.

5 Replies

Related Content

Jinja Expression Comparing Now to Now+Hours

Same reference field, different selections within the form

Multiple reference proxy fields help

Managing record access for multiple data levels

Search different string from multiple records

Recent Discussions

Pipeline API Post

Back to basics: Pulling info from a grand-parent table

File Attachment Field in Pipelines

Can I use quickbase actions within the same table?

Question about relationships