Skip to main content
Question

Checkbox Formula based on Date

  • July 14, 2022
  • 0 replies
  • 35 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement