AnsweredAssumed Answered

Converting Text to Dates

Question asked by bterrell721 on Apr 12, 2013
Latest reply on Apr 16, 2013 by philmodjunk


Converting Text to Dates


     Hello All,

     Just need some quick help coming up with a functioning calculation for a particularly tricky conversion (at least for me!).  I have a text field that represents dates either in the MM/DD or MM/DD/YYYY formats (single or double digit months and days could be present) and I need to create a new field that is a calculation resulting in a Date that is five days prior to the one listed in the original text field using the current year.  

     For example:  

     Text: 4/21 should convert to Date: 4/16/2013

     Text: 04/02/1989 should convert to Date: 3/28/2013


     Thanks in advance for assistance on making this happen for me!