Part of string to datetime

[bist]

I have a string field that says
Deadline set to "10.09.2003 09:23 ECT"

Can anyone help me with how to take out the date/time and convert it to a datetime-field?

Thanks!

Britist

 

[Madawc]

try CDateTime(your.string)

Madawc Williams
East Anglia, Great Britain

 

[lbass]

Something like this might work:

stringvar comment := {table.string};
stringvar extractdatetime := mid(comment,instr(comment,'"')+1, instrrev(comment,'"', -1) - instr(comment,'"')-5);
cdatetime(replace(extractdatetime,".",",&quot);

This also eliminates the "ECT" (which you can't include in the conversion to datetime) so that the result using your example above would be:

10/09/2003 09:23:00AM

-LB

 

[synapsevampire]

Or:

cdatetime(replace(left({table.field},16),".","/&quot)

This eliminates the timezone, if you need to allow for various timezones, you'll need to use a formula or a UFL (milletsoftware.com has a UFL.

-k