CA Service Management

  • Private Community
 View Only

  • 1.  change date format in filter

    Posted Feb 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:
    mm/dd/yyyy

    OR 

    dd/mm/yyyy

     

    Thank you,
    Regards,
    Marco Velazquez



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

    Posted Feb 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,

    Brian