I am very new to PB.
My report requirement is this.
Ask the user to type in two dates, FromDate and ToDate.
Take the value of those dates, and query the Employee table to retrieve all employees whose hire_date is between these two dates.
So, on my base sheet I created two single line edit boxes
named FromDt, and ToDt. And I have Submit button.
The way it's working right now is no matter what the user types in the FromDt, and Todt when they click on submit they get every row in the Employee table.
My problem is that I do not know what to put in the SQL "Where" clause. I think the syntax should be,
SELECT Empname, Empid
WHERE hire_date BETWEEN :fromdt AND :todt
but when I do the above, a box pops up asking me to enter the value for fromdt, and todt. I want it to take the value from the single line edit boxes.
Can someone please tell me how I can tie what the user types in the two date fields to my sql query? I am having so much trouble, and the boss is sitting on my head waiting for me to finish up, without helping. Thank you so much. Please explain in detail the steps required because I am very new to PB. We are using PB 8.0. Again, thank you so very much! I only have 50 points....