I was in the mood for a puzzle
// change Completed to a vertical Pipe | character
// nothing special about the | but it is rarely used by users.
var text LogWithPipes = SearchAndReplace([Status], "Completed", "|");
var text RemoveAfterPipe= NotRight($LogWithPipes, "|");
var text CompletedEntry = Right($RemoveAfterPipe, "[");
var text DateAndTime = Left($CompletedEntry,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: 11-10-2020 13:46
From: Nathan Allan
Subject: Access the date/time in a logged field?
------------------------------
Nathan Allan
Original Message:
Sent: 11-10-2020 13:39
From: Mark Shnier (YQC)
Subject: Access the date/time in a logged field?
Can you post an example
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 11-10-2020 12:59
From: Nathan Allan
Subject: Access the date/time in a logged field?
How would I do this based on the most recent completed status?
------------------------------
Nathan Allan
Original Message:
Sent: 11-09-2020 17:15
From: Mark Shnier (YQC)
Subject: Access the date/time in a logged field?
If 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
Original Message:
Sent: 11-09-2020 14:36
From: Paul Peterson
Subject: 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
------------------------------