Forum Discussion

BobThomas1's avatar
BobThomas1
Qrew Cadet
3 years ago

I need to use the following field in a date range

I need to use the following field in a date range [cln enc date - date] It's a date-formula field. I am trying to check for current dates, within last week (7 days) last week 8-14 days and then 1...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
Try this as a formula text field to tag the date range.

IF(
[cln enc date - date] > Today(), "Future",
Today() - [cln enc date - date] <= days(7), "Current Week",
Today() - [cln enc date - date] <= days(14), "Last Week",
Today() - [cln enc date - date] <= days(21), "Previous Week", "Older Weeks")







------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
TonyaJacques's avatar
TonyaJacques
Qrew Member
2 years ago

would this formula apply to a field that uses numbers instead of a date but still a range? For example: if ([days open] <= 0-22 and [HIPO/HVL] = "HVL", "In Progress")



------------------------------
Tonya Jacques
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    Are you trying to check if the numeric value is between 0 and 22?

    If so, then it would be

    IF(

    [days open] >=0 and [days open] <= 22 and [HIPO/HVL] = "HVL", "In Progress")



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • TonyaJacques's avatar
      TonyaJacques
      Qrew Member
      2 years ago

      Yes that worked for me! Thank you!



      ------------------------------
      Tonya Jacques
      ------------------------------
      • BobThomas1's avatar
        BobThomas1
        Qrew Cadet
        2 years ago

        I was on vacation, actually six pet sitting (4 cats & 2 dogs), so I printed this out when I got home. I will look at.

        I actually was going to work on this task, and see I posted a year ago. Thanks, may have time tomorrow.



        ------------------------------
        Bob T.
        ------------------------------