Writing a query from drop down /check box

[Taidaisher]

Hi. I have an analytic app that allows users, via two Date tools, to select the start & end dates to be used for query. The SQL statement, grabs several different fields from the DB, where the date range is greater then the start date and less then the end date.

select blahblahblah where date >= '1-july-2018' And Date <= dateadd (day,1, '30-september-2018')

I would like to modify the app, so the users select from a drop down list of quarter options, which then passes the start/end date for the query.

Any suggestions?

[AndrewDMerrill]

Here is a sample

[Taidaisher]

Thank you ADM, definitely got me closer to my goal.

[AndrewDMerrill]

You are very welcome! If your question has been answered satisfactorily, please like and mark solution to help others find the answer!