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

Question

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

markshnier__you · Answer

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

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

markshnier__you · Answer

Try one of these.&nbsp;
Most Recent &nbsp;EntryTrim(Right(Part(NotLeft([append at top],1),1, "["),"]"))
Date of Most Recent EntryToDate(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------------------------------

Forum Discussion

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

3 Replies