CA Service Management

  • 1.  Remove Time from Date Field

    Posted Mar 16, 2017 01:22 AM

    Hello,

    i want to remove the time field form the date variables in report builder how can i do this

     



  • 2.  Re: Remove Time from Date Field

    Posted Mar 16, 2017 04:52 AM

    Hi,

    Not sure you can

    Why will you do that knowing that the time is defaulted already to 00:00:00?

    /J



  • 3.  Re: Remove Time from Date Field

    Posted Mar 16, 2017 04:59 AM

    Hi,

    i have created a table with the date column with the format as m/dd/yyyy(without time field) .

    i was designing a form where the user select the date parameter  and the corresponding report will publish.

     

    regards

     

    farooq



  • 4.  Re: Remove Time from Date Field

    Broadcom Employee
    Posted Mar 16, 2017 06:01 AM

    Good Morning Farooq.

     

    Researching for this question shows me that this is not possible.

    Managing and/or creating variables in SC/Admin/Report Builder/Data Object, does not show any possibility to remove the time section from the 'date'-type variable.

     

    The next proposal then is to open an Idea in this same community.

    To see whether it would be possible to implement such in a future release of the product.

     

    Thanks and kind regards, Louis van Amelsfort.



  • 5.  Re: Remove Time from Date Field
    Best Answer

    Posted Mar 17, 2017 11:45 AM

    Hi Louis,

     

    i manage to do it with the below steps

    -------------------------------------------------------------

     

    What to customize ?
    File: USMHONE\view\webapps\usm\explorer\scripts\reportsgenericgetvariables.js
    Changes Needed:
    function createRow(strRowString, argNum)
    Change #1
    Comment out following line:
    td2.appendChild(span2);
    Change #2
    Add the following BOLD line:
    input2 = document.createElement("INPUT"); input2.id = strName + "TIME"; input2.maxlength = "11"; input2.size = "11"; input2.value = defTime; input2.style.display="none";td2.appendChild(input2);