Skip to Content

Problem with Date prompt in Webi report


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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers