Skip to Content
0

Problem with Date prompt in Webi report

Apr 13, 2017 at 05:24 AM

39

avatar image
Former Member

Hi,

we have Webi report to show the output columns as Batch ID, Document ID, Create Date.

Input Parameter is Create Date Range.

Problem is when we enter create date range input values as 01.04.2017 08.00 and 13.04.2017 08.00, the output of the result shows from 10.01.2017 to 13.04.2017 records in Batch ID, Document ID, Create Date, but we need the records only from 01.04.2017 08.00 to 13.04.2017 08.00

The report is based on Derived Table, In derived table we have written code for Create Date prompt as To_char(TableName.CREATEDATE,'DD.MM.YYYY HH:MI') "Create Date".

Can any one help me out with the solution.

Thanks & Regards,

Ravi Shankar

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers