Access the date/time in a logged field?
I have several note fields that employ the Log entries option. Is there any way to get the date and time of the last entry? ------------------------------ Paul Peterson -------------------------...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf the new entries are at the bottom of the list, then this formula for a date time formula field will parse out the date/time into a date/ time field type. You just need to edit the first line to put in your own [field name].
var 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.com
mark.shnier@gmail.com
------------------------------
var 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.com
mark.shnier@gmail.com
------------------------------
- How would I do this based on the most recent completed status?
------------------------------
Nathan Allan
------------------------------- MarkShnier__YouCan you post an example
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Nathan Allan
------------------------------
