Date filter start on current day

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a couple of filters on the left side of my report screen.  The first one is "Date" as the report is a list of timecards.  The "Start Date" defaults to the record (timesheet) that is the earliest in the system.  Is there a way to have the "Start Date" filter default to the current day so that users do not have to change the date from a previous year every time they filter? 

I do need the ability to filter for all dates from the filter so I don't want to hard code a start date that can't be manually changed (in the pop out calendar) while filtering.  Thanks in advance!

Aaron
Photo of Aaron Zielinski

Aaron Zielinski

  • 272 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
No problem.

I suggest that you make a new field called [Today?].  Make it a formula field with the formula of 
IF([my date field]=Today(), " Yes, no")

Then include that field as a Dynamic filter on the report.