5 Replies Latest reply: Nov 28, 2016 10:41 PM by Buminda Nawagamuwa RSS

    concatenating a string and expression output

      HI all

               i am facing problems in concatenating two values

               scenario: i have a date 6/30/2012, but i want to display it as Q2 2012

               how can i do that?

               i thought of concatenating Q2 with =year(today())-1, but it doesnt work

               or can i use some variable, if so how?

               pls assist me.


      thanks in advance