Filter Date on Report

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I'm trying to make a new report that filter my client database for clients whose date of birth falls in the next month. I had created a new table report and under 'filter' I had made sure to select clients whose date of birth is during the next 1 month. I know I have a at least a dozen clients who have birthdays in February, but my report is blank.

My ultimate goal is on a monthly basis to run a report of client's birthdays for the next month.
Photo of Lynn

Lynn

  • 0 Points

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
make a formula checkbox field

FirstDayofMonth(Adjustmonth(Today(),1) = FirstDayofMonth([DOB])