Forum Discussion

ChrisCollins's avatar
ChrisCollins
Qrew Trainee
2 years 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
2 years 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
------------------------------