Extract a date from the middle of a logged field
I'm trying to extract a date into a formula date field from a logged field that isn't necessarily on the top or bottom of the log. It could be, but it could also be in the middle.
I need the date associated with the "living with" selection from a multiple choice field.
The formula i thought was working is
If(Contains([Type Log],"Living with"),
ToDate(Left(Right(NotRight([Type Log],"Living with"),"["),9)),null)
But then i realized if there was another entry below the "living with" entry, it was grabbing that date instead.
Is this possible?
Thanks!
------------------------------
Trish Wehrle
------------------------------
I need the date associated with the "living with" selection from a multiple choice field.
The formula i thought was working is
If(Contains([Type Log],"Living with"),
ToDate(Left(Right(NotRight([Type Log],"Living with"),"["),9)),null)
But then i realized if there was another entry below the "living with" entry, it was grabbing that date instead.
Is this possible?
Thanks!
------------------------------
Trish Wehrle
------------------------------
