Converting Text to Dates
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.
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!