>>Are there any VFP functions or 3rd party routines that can convert a date to text. IE 11/23/2002 converts to "23rd day of November, 2002"
>>
>>Thanks for you help
>>Stephen Hunt
>
>alright, here is one which should work, even with the '11' mentioned earlier:

Nope, you're on the right track, but still missed the 12th and 13th. Just add those, too, and it'll work.

>FUNC Date2String
>	LPARA ;
>		LcDate
>	Local ;
>		LcDay, ;
>		LcMonth, ;
>		LcYear
>	
>	LcDay = ALLT(STR(DAY(LcDate)))
>	DO CASE
>		CASE RIGHT(LcDay, 1) = "1" .and. LcDay <> "11"
>			LcDay = LcDay + "st"
		CASE RIGHT(LcDay, 1) = "2" and LcDay <> "12"
>			LcDay = LcDay + "nd"
		CASE RIGHT(LcDay, 1) = "3" and LcDay <> "13"

>			LcDay = LcDay + "rd"
>		OTHERWISE
>			LcDay = LcDay + "th"
>	ENDCASE
>	LcMonth	= CMONTH(LcDate)
>	LcYear	= ALLT(STR(YEAR(LcDate)))
>	RETURN(LcDay + " day of " + LcMonth + ", " + LcYear)
>ENDFUNC
>