August 27, 200718 yr Newbies Is there an easy way to parse the text "August 8 2007" to an actual date for processing? I can think of lots of hard ways, but no easy ones.
August 27, 200718 yr If you format you result from the calcfield as date could it be done this way: Date ( Position ( "**janfebmaraprmayjunjulaugsepoctnovdec" ; Lower(Left ( theProvidedTextualDate ; 3 )) ; 1 ; 1 )/3 ; MiddleWords ( theProvidedTextualDate ; 2 ; 1 ) ; RightWords ( theProvidedTextualDate ; 1 ) ) --sd
Create an account or sign in to comment