Forum Discussion

SeanBoat-Moore's avatar
SeanBoat-Moore
Qrew Trainee
2 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 fields are 
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.'" & [Start Date] &"'}AND{6.OBF.'" & [End Date] & "'}) "), 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. 

Thanks


------------------------------
Sean Boat-Moore
Hospitality Solutions Development Manager
NCR Corporation
sean.boat-moore@ncr.com | ncr.com
------------------------------

3 Replies

Sort By
  • DanaHauser's avatar
    DanaHauser
    Qrew Cadet
    2 years ago
    What about simply running a report and set the Sort and Group by Date?

    ------------------------------
    Dana Hauser
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    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's avatar
      SeanBoat-Moore
      Qrew Trainee
      2 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
      ------------------------------