Pulling Date/Time info from a Memo Field

[heathercraw]

Hello,

How would I pull out the date/time stamp from a memo field with the following format:

4/11/2007 11:26:31 AM Suzy Sting
Assigned to Individual changed from to Tami Shortridge

The Status field has changed from Assigned to Work In Progress


Thank you for any and all assistance provided,

Heather

 

[lbass]

You could try a formula like this:

if not isnull({table.memo}) then
datetime(
split({table.memo}," ")[1]+" "+
split({table.memo}," ")[2]+" "+
split({table.memo}," ")[3]
)

This would make the string a datetime field. If you want it to remain a string, remove datetime().

-LB