Same Field Filter for 2 variables in the same query

Get Help
1

Below is my query. I want to use Field Filter for the ProgramCreatedDate and ProgramUpdatedDate to have access to the same date filter in the dashboard. In my case, when I tried to do link the dashboard filter to the variables, only one of the two can be linked and I don't want to create another filter widget also. What should I do

SELECT COUNT(ProgramID) as
FROM Database
where {{ProgramCreatedDate}} OR {{ProgramUpdatedDate}};

2

Hi @tien
You would either need to use simple Date variable, or have a lookup table with all dates, which you can then get the min/max dates from, which you can use on the two columns.