CA Service Management

Expand all | Collapse all

change date format in filter

Jump to Best Answer
  • 1.  change date format in filter

    Posted 02-20-2019 12:38 PM

    Hello everybody,

    Currently, I am working with a report, in CABI 4.1
    I added a date filter, but when I select it it appears with the format:
    mm/dd/yyyy hh:mm:ss AM/PM.


    There is a way to change the format, so that it only appears as follows:




    Thank you,
    Marco Velazquez

  • 2.  Re: change date format in filter
    Best Answer

    Posted 02-20-2019 02:42 PM

    Hi Marco,


    You could try modifying the 'ODBC.PRM' located on '~CA\SC\CommonReporting3\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\odbc\' and set the following line to:



    <Parameter Name="USER_INPUT_DATE_FORMAT">{\d 'yyyy-mm-dd'}</Parameter>



    Kind Regards,