Forum Discussion
MarkShnier__You
2 years agoQrew Champion
I believe that this can be done with a formula query. But the syntax for those is tricky especially without access to the app. I can help debug if you take a shot at it or else it may need a shorty one on one session to get it working.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- DawnRene32 years agoQrew TraineeThanks Mark. Let me take a stab at it this weekend and I'll connect with you on Monday!--
- MarkShnier__You2 years agoQrew ChampionThe goal of the formula query will be to it extract a text list of all of the dates for that same coach and child combination where the date was before the date on the record.
I'm pretty sure they will come back in the sequence of Record ID number. So the one at the right side of the string will be the piece of text to hive off and convert to a date.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------