2 Replies Latest reply: May 21, 2014 10:36 AM by Steve Zagzebski RSS

    Previous Month from text field

    Steve Zagzebski

      I have an "Effective Date" text field in the following format:

       

      ex.  Effective Date = 20140410  ( April 10 of 2014)

       

      I need to be able to change this to a text field that would represent the previous month (in a YYYYMM format):

       

      20140410  becomes 201403

      20140115  becomes 201312

       

      Thanks for any help in advance,

       

      Steve