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
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.
      ------------------------------