2 Replies Latest reply on Dec 6, 2016 8:42 AM by genman

    Automatically copy text from a field and adding dashes in between


      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,