Skip to main content
Question

Extract a date from the middle of a logged field

  • May 28, 2020
  • 0 replies
  • 89 views

Forum|alt.badge.img+4
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You will to use the SerachAndReplace function to replace "Living with" with say a "|".  Then look for that | character for your formulas post back if you are stuck.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------