>I have a table with memo field where a datetime can be entered at various points in the field
>
>How can i extract this datetime?
>
>example for {04/09/2009 11:18:26 AM}
>
>

some text entered with date time field 04/09/2009 11:18:26 AM and then some more text</pre >
>
>and i need to extract the "04/09/2009 11:18:26 AM" or what ever datetime is present
>thanks in advance

Something like this:

Create Cursor results (result T)
Index On result Tag result
cText="some text entered with date time field 04/09/2009 11:18:26 AM and then some more text"
nLen=Len(cText)
For nLoop=1 To nLen
	cTrialtext=Substr(cText,nLoop,22)
	tTrial=Ctot(cTrialtext)
	If Empty(tTrial)
		Loop
	Endif
	If Seek(tTrial,'results','result')=.T.
		Loop
	Endif
	Insert Into results Value(tTrial)
Endfor
Select results
Browse
Close Databases All