4 Replies Latest reply on Aug 22, 2013 9:54 PM by Alex Kerin

    How to concatenate year and month?

    Gautam S

      Hi Everyone

       

      I have a datetime field .for  e.g. 2013-08-22 12:00:00 AM. I want to concatenate the year and month and i want the output as 201308.

      When i try year (datetime_field)+month(datetime_field) what i get get is 2013+08=2021  .. i.e it adds instead of conactenating. Can someone pl tell how to get the output as 201308?

       

      Regards

      Gautam