7 Replies Latest reply on Sep 6, 2018 7:31 AM by Zhouyi Zhang

    Select rows based on computed date range values

    Aseem Goyal

      I have multiple columns in MYSQL database and 4 of them are hour, day, month, year.

       

      Now, i want to create 2 date parameters - start date and end date. The user will select this parameter and i want to display content from the data which only lies in the given date range.

       

      For example the user selects as the start date and end date as 31/01/2018 and 20/05/2018.

      How can i achieve my use case?