How do I...?

How to Create a Date Filter for Today() or Now() ?

I am trying to create a filter against a Date field to display all records prior to today, but I am only able to select a specific date from a pop-up calendar control.

0 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
John McGarvey shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Derrick Kotlus commented  ·   ·  Flag as inappropriate

    Hi John,

    At the moment, we do not have the ability to select "today" or "now" in a date filter. That being said, we are in the process of improving filters by adding more options. Be on the lookout for additional options in the future!

    In the mean time, you can create a calculated field in your table that outputs a 1 if the date is prior to today. You can then create a filter on this new field effectively creating this "is before today" filter that you are looking for.

    Regards,

    Derrick

Feedback and Knowledge Base