Forum Discussion

Qrew Trainee

3 years ago

List all records with date in a range

We have a table that lists everyone's upcoming time off, called team calendar. I'm trying to use Get Field Values to show me a list of everyone who has requested off at the same time. The relevant...

MarkShnier__You

Qrew Legend

try this. I assume fid 6 is the start date and 7 is the end date.

ToText(
GetFieldValues(
GetRecords("{15.EX.'Vacation'}AND({6.OBF.'" & [END Date] &"'}AND{7.OAF.'" & [Start Date] & "'}) "), 7))

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

SeanBoat-Moore

Qrew Trainee

3 years ago

That did it Mark.

Thanks!!!

------------------------------
Sean Boat-Moore
Manager SMB Development
Project Management Office and Quality Control
NCR Corporation
sean.boat-moore@ncr.com | ncr.com
------------------------------