List all records with date in a range

Question

We have a table that lists everyone's upcoming time off, called team calendar.&nbsp; I'm trying to use Get Field Values to show me a list of everyone who has requested off at the same time.&nbsp;&nbsp;The relevant fields are&nbsp;
Type, fid 15
User, fid 7
Start Date (of Time off), fid 6
End Date (of Time off), fid 18
This is the formula I have now
ToText(GetFieldValues(GetRecords("{15.EX.'Vacation'}AND({6.OAF.'" &amp; [Start Date] &amp;"'}AND{6.OBF.'" &amp; [End Date] &amp; "'}) "), 7))Unfortunately it's only showing me values where the start date matches the start date of the new request, where I need to get any request that occurs on that date, even if it's in the middle of a request range.&nbsp;Thanks------------------------------Sean Boat-MooreHospitality Solutions Development ManagerNCR Corporation sean.boat-moore@ncr.com  |  ncr.com------------------------------

danahauser · Answer

What about simply running a report and set the Sort and Group by Date?------------------------------Dana Hauser------------------------------

markshnier__you · Answer

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

That did it Mark.&nbsp;&nbsp;Thanks!!!------------------------------Sean Boat-MooreManager SMB DevelopmentProject Management Office and Quality Control NCR Corporation sean.boat-moore@ncr.com  |  ncr.com------------------------------

Forum Discussion

List all records with date in a range