Forum Discussion

ChrisCollins's avatar
ChrisCollins
Qrew Trainee
7 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 da...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

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
------------------------------
ChrisCollins's avatar
ChrisCollins
Qrew Trainee
7 months ago

The Word.doc I attached shows the field properties and an example of live data in the form. Thanks for your help, Mark! 



------------------------------
Chris Collins
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    7 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
    ------------------------------