Automatically copy text from a field and adding dashes in between

Discussion created by genman on Nov 25, 2016
Latest reply on Dec 6, 2016 by genman

Source Field contains the following data : 

Record 1: 161125-01;

Record 2: 161125-02;

Record 3: 161120-03, etc.


Date Field:

Record 1: 16-11-25;

Record 2: 16-11-25;

Record 3: 16-11-20, etc.


I would like take data from the source field to become a date entry in another field as per example above.  The first six digits of the source field is a date with -01; -02; -03, etc. at the end.  I need another field to be a date.  Is there any way of doing this automatically without having to type it in manually for each record?


Thank you,