MarkShnier__You
Qrew Legend
3 years agoRe: Formula Date Field to Extract Date from Log Entry Field?
Where is a complete set of formula is when the append only newest entries are at the top is at the top.
Most Recent Entry
Trim(Right(Part(NotLeft([append at top],1),1, "["),"]"))
Date of Most Recent Entry
ToDate(NotLeft(Left([append at top], " "),1))
Name who did the most recent entry
NotLeft(Left([append at top], "]"),11)
------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------
Most Recent Entry
Trim(Right(Part(NotLeft([append at top],1),1, "["),"]"))
Date of Most Recent Entry
ToDate(NotLeft(Left([append at top], " "),1))
Name who did the most recent entry
NotLeft(Left([append at top], "]"),11)
------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------