I am solving one use acse and i want to extract year from birth date how to do it
To extract the year from a birth date in Process Studio, the exact method depends on whether your field is currently formatted as a Date data type or a String (text) in the stream.
The two steps for this are:
-
Calculator Step
-
New field:
Birth_Year -
Calculation:
Year of date A -
Field A:
[BirthDate]
-
-
Formula Step
-
New Field:
Birth_Year -
Formula:
YEAR([BirthDate]) -
Value Type:
Integer
-