7 Replies Latest reply on Sep 2, 2018 7:58 PM by Shinichiro Murakami

    Extract Year from string

    yuji minami

      Hello there,

       

      I need to get a "4 digit year" from a string like this. I've tried string function like "Right()" but have no luck...

       

      Could anyone help me with this?

       

      There are customers with or without date of birth captured like these. Some customers have just DOB and some have some parameters after DOB.

       

      No date of birth

      {"5":"","6":"","1":"2","3":"4"}

       

      Date of birth

      {"5":"9","6":"1973-10-04","1":"2","3":"5"}

       

      Date of birth

      {"5":"9","6":"1982-06-27"}

       

      Hope to hear your insight!

       

      Thanks in advance.

      Yuji