6 Replies Latest reply: Jul 17, 2017 6:02 AM by Tresesco B RSS

    Concatenate Month & Year to Single Date Field

    Phil Speight

      Hi

       

      I want to create a single date field in my script data which combines 2 fields together:

       

      Finance_Month (January, February, March, April, May, June, July, August, September, October, November, December)

      Finance_Year (2015, 2016, 2017)

       

      I want to combine them to return the following in a date format

       

      April 2015, May 2015, June 2015 July 2015 ........


      How do I do this?



      Many thanks





      Phil