Run Query with replacing two different date types using Radio Buttons

[bobbybalan]

I have a query that should run depending on the type of the date an user selects. I am thinking to have two radio buttons - Sale Date and Payment Date and two Date Interface tools for date1 and date2 selection.  Any idea is much appreciated.

So depending on the date type selected, the query should execute for the entered date values. 

if Sale Date radio button selected -

select field1, field2 from table 1 where sale_date >= date1 and sale_date <= date2

if Payment Date radio button selected -

select field1, field2 from table 1 where payment_date >= date1 and payment_date <= date2

[phottovy · Accepted solution]

Hi @bobbybalan,

Attached is a pretty basic app that lets you choose between two different date fields. The second radio button is really just cosmetic and the column changes based on the Sale Date button.