Forum Discussion
MarkShnier__You
Qrew Champion
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
------------------------------
// 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
------------------------------
NathanAllan2
4 years agoQrew Member
Perfect. Thanks a ton!
------------------------------
Nathan Allan
------------------------------
------------------------------
Nathan Allan
------------------------------