Assistance with a trim formula

Question

I am using the following formula in a text formula field to trim out just the value (which is a date) of a log edits text field.&nbsp; The formula is including the ------------ after the user name in the log field and I'd like to exclude them.&nbsp; Is there a way to do this?

Trim(Right([my update field],"]"))

Log Edits Field Value
-- [JUL-03-23 Rachel Miller] --------------06-30-2023
Formula Field Results
--------------06-30-2023
------------------------------Rachel Miller------------------------------

markshnier__you · Answer

try this
Trim(Right([my update field],10))

That will take the 10 rightmost characters.

But then I suggest changing your field type to be formula date

ToDate(Trim(Right([my update field],10)))------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

rachelmiller · Answer

Thanks Mark.&nbsp; Both of these work however I forgot to mention that my logging field is set to put new entries at the top instead of the bottom.&nbsp; This is because the field is logging dates and we want to see the most recent date at the top.&nbsp; Can the formula be adjusted for that or do I need to change that setting?&nbsp; I don't have a lot of data loaded yet so I can reload it if the setting has to be changed.------------------------------Rachel Miller------------------------------

markshnier__you · Answer

Can you copy and paste (not a screen shot) what the data look like for a multiple entry logging?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

rachelmiller · Answer

Last Access Date is the logged field and Last Accessed - Date Only is my formula field.&nbsp; I should also mention that I didn't have logging turned on initially which is why you don't see it as a log entry for 06-16-2023.

Last Access Date
-- [JUL-03-23 Rachel Miller] --------------06-30-202306-16-2023

Last Accessed - Date Only
06-16-2023
------------------------------Rachel Miller------------------------------

markshnier__you · Answer

This should work, but but only if you show the updates on one line - it's too difficult to deal with those extra hyphens.&nbsp;&nbsp;

Show the name and date on the same line as the entry------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Assistance with a trim formula