Forum Discussion

UrsulaLlaveria's avatar
UrsulaLlaveria
Qrew Assistant Captain
5 years ago

Is Today within date range

I am having a brain fart and cannot remember how to calculate if a Date is within a date range field. Since the old blog posts are down right now, I can't peruse and look for it. Any and all suggestions would be appreciated.

------------------------------
Ursula
------------------------------
Formulas and functions
  • MeredithMoore5's avatar
    MeredithMoore5
    Qrew Assistant Captain
    5 years ago
    If([date]>=[start date] and [date]<=[end date], true, false)

    ------------------------------
    QuickBase Girl
    ------------------------------
    • UrsulaLlaveria's avatar
      UrsulaLlaveria
      Qrew Assistant Captain
      5 years ago
      Thanks Quickbase Girl! Of course, this is a bit more complicated than that (surprise). What I am trying to accomplish is to display all users that are on PTO for today. So if a user has a date range of 5 days, if one of those days is Today(), display their name. Your formula gets me halfway there, now I need to figure out the rest. thank you!!

      ------------------------------
      Ursula
      ------------------------------
      • BlakeHarrison's avatar
        BlakeHarrison
        Qrew Captain
        5 years ago
        That's all going to depend on how your PTO is setup. You may want to consider a setup where you would end up with a single record for each Day/Employee combination. You can still have an Employee-facing setup that may represent an entire week, but then have Pipelines generate those single day records. With that, you'd be able to setup a PTO Calendar Report.

        ------------------------------
        Blake Harrison
        bharrison@datablender.io
        DataBlender - Quickbase Solution Provider
        Atlanta GA
        404.800.1702 / http://datablender.io/
        ------------------------------