Extract Date from Logged Field
I'm trying to extract a date from a logged field. In the example below, I am trying to get the Backlogged Date. I figured I could use a series of 'left', 'right', 'notleft' etc. However, my first try ...
Forum Discussion
Mark,
I have success pulling from the most recent field. But there will be instances where the date I want is not the most recent selection. That is why I was trying to base it off a word. Ever have success pulling a date from a field that could be 1st, 2nd, or 3rd....?
------------------------------
Mike Tamoush
------------------------------
I have success pulling from the most recent field. But there will be instances where the date I want is not the most recent selection. That is why I was trying to base it off a word. Ever have success pulling a date from a field that could be 1st, 2nd, or 3rd....?
------------------------------
Mike Tamoush
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendI don't have a formula handy, but I would use SearchAndReplace to change the word to a pipe | and then do the "left / right" thing based off the location of that Pipe. | There is nothing special about a Pipe other than it is a character rarely used intentionally for data entry.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------