CA Service Management

  • 1.  Change Month in English to Spanish

    Posted Jan 03, 2018 01:35 PM

    Hi everyone
    Good Afternoon,

     

    I am Working with BOXI 4.1, and I created a report, but now my client needs the date (only month) in spanish

    Is it possible to change the lenguage of my month in my report?

     

    I use the following variable:

    =Month(CurrentDate())

    Regards,
    Marco Velazquez.



  • 2.  Re: Change Month in English to Spanish

    Broadcom Employee
    Posted Jan 03, 2018 03:27 PM

    Marco..........

     

    I have not tried this myself, but perhaps you need to add some logic into the report using a series of IF statements.

     

    For example, IF Month(CurrentDate()) = January then show "ABCDE", IF Month(CurrentDate()) = February then show "FGHIJK:.............

     

    Does any other CABI/BOXI expert have any ideas?



  • 3.  Re: Change Month in English to Spanish

    Posted Jan 03, 2018 04:17 PM

    Hi Paul.

    I comment you that I tried to use the syntax that you recommend me. but the syntax not working. any other idea?

     

    Regards,

    Marco V.



  • 4.  Re: Change Month in English to Spanish
    Best Answer

    Posted Jan 03, 2018 07:11 PM

    Hi Paul.

     

    I Comment you, that I changed the values and the syntax run correctly.

     

    =If MonthNumberOfYear(CurrentDate())= 1 Then "Enero" ElseIf MonthNumberOfYear(CurrentDate())= 2 Then "Febrero" ElseIf MonthNumberOfYear(CurrentDate())= 3 Then "Marzo" ElseIf .....

     

     

    thank you very much

    Marco Velazquez.