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 suggestio...
Forum Discussion
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
------------------------------
------------------------------
Ursula
------------------------------
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/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------