Forum Discussion

ChrisCollins's avatar
ChrisCollins
Qrew Trainee
6 months ago

Generate Date Calculations from a Date Stamp in Text-Mulitline Field

I built a CRM in QuickBase a few years ago and enabled Log Entries to date stamp when my Sales Reps update the Status Update field (Text- Multiline). I now want to know if there's a way to use the date stamp and generate a report showing when they last updated this specific field.

I appreciate any help to achieve the desired outcome.



------------------------------
Chris Collins
------------------------------

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    6 months ago

    Yes there is. Please post an example of your field so we can see how it formats. 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        6 months ago

        Try one of these. 

        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
        ------------------------------