Filter value list by date

Discussion created by 3rdcycle on Jul 6, 2017
Latest reply on Jul 7, 2017 by philmodjunk

Hi everyone


This should be a fairly common thing, yet I can't seem to find a simple solution on the forums or anywhere else.


I have an employees table with name, start_date and end_date fields. In a dropdown I want to show only the employees with with end_date empty or > today. What's the simplest way to filter my value list by date?