Find the last "Sent:" date/time in the list

[Former Member]

Is it possible to find the last "Sent:" date/time in the list without including the details after the AM/PM of that date/time.

An example of the message string is attached.

Thanks for any help,

Jen

Message.txt.zip

[abhilash_kumar]

Hi Jen,

What portion of the text towards the end would you like the report to display?

-Abhilash

[Former Member]

Hi Abhilash.

Only the last listed Date/Time.

[Former Member]

I suppose, to be more specific, the last date listed that has "Sent:" before the date.

[abhilash_kumar]

Please let me know if this works:

stringvar s := {string_field};

stringvar array ns := split(s, 'Sent: ');

Left(ns[ubound(ns)],9);

-Abhilash

[Former Member]

That seemed to work until I went to page 2.  I believe this is error is due to the date diff.  Is there  a way to turn the formula you sent me into a date/time field?   

[abhilash_kumar]

Sure, try:

stringvar s := {string_field};

stringvar array ns := split(s, 'Sent: ');

If isDate(Left(ns[ubound(ns)],9)) then

cDate(Left(ns[ubound(ns)],9)) else cDate(0,0,0);

-Abhilash