Discussions

 View Only
  • 1.  Checkbox Formula to Identify 3 Banking Days

    Posted 09-01-2020 09:28
    Good Morning, 

    I am stuck on trying to create a formula where if two separate dates are within 5 calendar days within each other, that they would place a check in a checkbox. I assume it is a using checkbox-formula field. 

    Better yet, is there a way to make Quickbase recognize 3 business days instead of just calendar days? For example; it does not include Saturday, Sundays, or Holidays. 

    More of an example, Memorial day this year was Monday, May 25th, 2020. If the first date is May 21st, and the second date is May 27th, it would recognize that this is only 3 business days since we had the weekend + a holiday. 

    If not, Just taking the 5 calendar days would be a huge help as described above. Any help on this would be greatly appreciated.  :)

    ------------------------------
    Dale Miller
    ------------------------------


  • 2.  RE: Checkbox Formula to Identify 3 Banking Days

    Posted 09-01-2020 12:07
    Are these fields on the same record?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Checkbox Formula to Identify 3 Banking Days

    Posted 09-01-2020 12:11
    Yes, same record. This is how I have the fields on my form. And I am wanting the date of last strike versus the date of exception to be part of the formula. 

    Date of exception would be a later date then the date of last strike is. 




    ------------------------------
    Dale Miller
    ------------------------------



  • 4.  RE: Checkbox Formula to Identify 3 Banking Days

    Posted 09-01-2020 12:18
    The formula for the number of business days between dates would be

    WeekDaySub([later field date], [earlier field date])

    That formula will skip weekends (but not holidays).

    Note that if the first date was Sept 1, 2020 and then 2nd date was Sept 2, 2020, then the result will be 1.  ie its not counting both ends of the range.  

    For a formula checkbox field you can try this

    IF(WeekDaySub([later field date], [earlier field date]) <=5, true)

    Holidays are tricky, and would probably require some one on one assistance.




    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------