Forum Discussion

dbryant4891's avatar
dbryant4891
Qrew Trainee
5 years ago

Formula Date Field to Extract Date from Log Entry Field?

Is there a formula, or a way, to have the date from a log entry field pulled into a separate field or into another formula?  Here's my setup and what I'm trying to accomplish: 1. A hearing is com...
Formulas and functions
BryanHelgeson's avatar
BryanHelgeson
Qrew Member
3 years ago
What do you do if the most recent entry is at the top of the list?

------------------------------
Bryan Helgeson
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
This formula will probably work to parse out the most recent entry. But I have not tested it in years.


Trim(Right(Part(NotLeft([append at top],1),1, "["),"]"))

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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)
    mark.shnier@gmail.com
    ------------------------------