Checkbox Formula based on Date

Question

I want to have a report that filters the records if todays date falls between the "Scheduled Start Date" & "Scheduled End Date".

Im confident this can be done with a formula checkbox that compares todays date with the scheduled dates and if it meets the criteria, check the checkbox, then filter the report based on the checkbox.

If anyone has any suggestions on the code that you would use, or even a better way to do it, please post below. Much appreciated!

------------------------------
Jordan Thompson
------------------------------

markshnier__you · Answer

I think that you are over complicating this.
Just make a report with two filters.

ALL

[Scheduled Start Date] is greater than or equal to Today (that will be a drop down choice)

[Scheduled Start Date] is Less than or equal to Today

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

jordanthompson · Answer

Thanks Mark, this will work.Sometimes the simple solution is the best one.------------------------------Jordan Thompson------------------------------

Forum Discussion

Checkbox Formula based on Date