Skip to Content
0
Former Member
Sep 14, 2011 at 05:12 AM

Date Range in Query

572 Views

Hi All,

We have created a query report which we have created as a stored procedure and we are executing the sp in SBO to get the result. However, there is one issue, we have passed the variables in the sp as well as the fms to get the date range, but if we input the date manually, the result shown is incorrect!!

It works fine when we tab on the from date, scroll down and select the date from the cfl!! This is not acceptable to the client. They want to enter the dates manually and not select from the cfl.

Please advise what is wrong here and how to correct this issue?? Is there any limitation of this sort..

Thanks,

Joseph