4 Replies Latest reply on Aug 30, 2018 9:37 AM by John Petty

    How to create year and month date field from a string

    John Petty

      I'm sure this has been asked before but I couldn't find a direct answer in the forum.

       

      I have a field [Invoice #] that has the format 180100001, 180200001, 180300001, etc...  The first two characters are the year and the next two characters are the month.

       

      How can I extract the first four characters to create a YYYYMMM Date field (2018 Jan, 2018 Feb, 2018 Mar, etc...?