CA Service Management

  • Private Community

  • 1.  CABI 4.1 need to get the current date, convert date

    Posted Aug 19, 2015 10:10 AM
      |   view attached


    Hi,

     

     

    Need to add current date in CABI 4.1 objects for getting the open date to current date time difference. What do we use as the current date function in CABI 4.1?

     

    Also need to convert time_spent(currently in ms) value to hh:mm:ss format. have tried the below formula, however, it is not working.

     

    Kindly suggest.

     

     

    Regards,

    Priyanka

    Attachment(s)

    zip
    time format.txt.zip   231 B 1 version


  • 2.  Re: CABI 4.1 need to get the current date, convert date

    Posted Aug 19, 2015 10:15 AM

    Hi,

    did you saw this doc?

    Advanced Reporting 201: Displaying duration as 00:00:00 time format



  • 3.  Re: CABI 4.1 need to get the current date, convert date

    Broadcom Employee
    Posted Aug 19, 2015 11:49 AM

    Priyanka,

     

    Would you be able to clarify which product reports are in question?

     

    SDM reports especially need slightly different approaches -  https://wiki.ca.com/display/CASM1401/Write+CA+Business+Intelligence+Reports#WriteCABusinessIntelligenceReports-PDMFunctions  Some useful SDM universe filters are also available on this thread - Useful Universe Filters   Thank you ftucker

     

    _R



  • 4.  Re: CABI 4.1 need to get the current date, convert date

    Posted Aug 20, 2015 03:06 AM


    Hi Gutis,

     

    Tried the fomula used in the link shared as below for the field time_spent from act_log table. however I am getting the error

     

    Formulat to convert second to HH:MM:SS

    concat(convert(varchar(5),floor(@Select(Admin Helpdesk\TimeSpent))/3600)),':',RIGHT(concat('0',convert(varchar(2),floor((@Select(Admin Helpdesk\TimeSpent))/60)-(60*floor(@Select(Admin Helpdesk\TimeSpent)))/3600)),2),':',RIGHT(concat('0',convert(varchar(2),floor(@Select(Admin Helpdesk\TimeSpent))-(60*floor(@Select(Admin Helpdesk\TimeSpent))/60)),2))

     

     

    Error:

    AHD12028:PdmSeconds argument alg.time_spent has invalid integer at time_spent- state:12028

     

    Please suggest.