Forum Discussion

Re: 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]
------------------------------
No RepliesBe the first to reply