Parsing Append Only Fieldsso... if you have a text field set to Log Changes where the new entries act in the default manner which is to be at the bottom of the updates, here are some formuals to use to parse out the values from the most recent entry. I am also assuming that you are logging the date and not the date and time.
Most recent value (formula text field type)Trim(Right([my update field],"]"))
Date of most recent update (this needs to be a formula date field)ToDate(Left(Right([my update field],"["),9))
Who did the most recent update (formula text field type)Trim(NotLeft(Left(Right([my update field],"["),"]"),9))
Parse out the date and time of the updatevar text DateAndTime = Left(Right([append only with date /time],"["),18);
var date TheDate = ToDate(Left($DateAndTime," "));
var timeofday TheTime = ToTimeOfDay(NotLeft($DateAndTime,9));
ToTimestamp ($TheDate, $TheTime)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 05-13-2020 14:18
From: Mike Tamoush
Subject: 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 led me to something that i can't figure out.
Simply trying: left([Field Name], "Backlogged") yields this result:
[Apr-08-20
That very much confuses me, so there is something I don't understand about how logged fields are stored. Can anyone shed light? I know I would need more in my formula to extract the date, but after getting that result I stopped as I was dead in the water.
I also tried left(totext([Field Name]), "Backlogged") with the same result.
------------------------------
Mike Tamoush
------------------------------