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

    Concatenate Month & Year to Single Date Field

    Phil Speight



      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