Hi Zandi,

Please follow below steps

Step1: Execute the script in Sql Server.

Step2: Open Smartobject tester utility and under ServiceObject  look for  SQL Server Service  and then expand this node.

Step3: Select your database and refresh it. If not available right click  on  SQL Server Service and select register service instance,

here provide the Database details under service keys and  click next  to proceed further to complete this step.

Step4: Now create a smartobject (this you can do any of  the two ways)
1) Create smartobject using SMO tester utility.

2) Using SMO designer create Smartobject for this procedure.

Step 5: Once Smartobject is created proceed for view creation

here you need to create two views one will show dates as subview (appears on screen when button click) and second will be your view with button.

view 1:

• Create a view let it name "View.ShowDates" of type listview. (remember to select checkbox for "Call this method when the form loads")
• Goto rules and edit rule "When the View executed Initialize"
• Click on configuration for action "then execute the List method (configure)"
• Under Input mapping details pass some vaild date for Date parameter
• Click on finsih and save this view.

view 2: 

• Create another view let name it "View.GetDetails"
• Add an button in view and under properties click on "Rules tab".
• Now add an action "Open a subview".
• click on "select view" (green color text ) and select view "View.ShowDates" created above.
• click finish and then save this view.

Let me know if this helps you.

The solution worked perfectly. 

Thank you.