Re: Access the date/time in a logged field?

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.com
mark.shnier@gmail.com
------------------------------