10 Replies Latest reply: May 29, 2016 9:05 AM by Peter Cammaert RSS

    Calendar object to pick multiple date types

    Lokesh Patel

      Hi Guys,


      In my data model I have more then 10 different Date Types.

       

      I have created 2 calendar objects to pick 'To' & 'From' dates

       

      What am I trying to do..

      I want the Users to chose type of date when they select 'To' & 'From' form the calendar object.

       

      Example:

      If user selects date type as 'Delivery Date' then it should only show orders delivered within selected date range.

      If user selects date type as 'Shipping Date' then it should only show orders shipped within selected date range.

       

      I have attached sample QVW with sample QVD with sample data set.


      About the attached Application..

      • I have created a date link table and then created a master table.
      • Two variables as 'vStartDate' & 'vEndDate' to select min and max date from common date field called 'Date'
      • Every time variable changes, a trigger will make selection in the 'Date' Field in Master Calendar

       

      Thank you in advance for your time, ideas and advice