Forum Discussion

JordanThompson's avatar
JordanThompson
Qrew Member
3 years ago

Checkbox Formula based on Date

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
------------------------------
  • 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's avatar
      JordanThompson
      Qrew Member
      Thanks Mark, this will work.

      Sometimes the simple solution is the best one.

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