AnsweredAssumed Answered

Full and Part Dates

Question asked by Mitch on Sep 21, 2010
Latest reply on Dec 13, 2010 by Mitch


Full and Part Dates



I have a portal that keeps a basic timeline.  It has two fields, "Date" and "Details'.  

Unfortunately, because of the type of data I need to keep some dates are not complete.  Example, one entry may have a full date of: 5/1/1888.  Another entry may one be a part date: 5/1888; being for May 1888. 

I have changed the field to a text field so the data can be entered.  However, it can not be sorted as a dates.  

Is there any method of being able to extract a date out of text can convert to a number of formats. Or a solution for part dates to be sorted along with full dates...?