Date Question

[Ron McKinney]

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.

[Søren Dyhr]

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