I have a text field that has the following data format:
Completed|John Doe|Monday, May 17th 2021, 3:15:19 pm|
I need to extract just the date and then make that into a date format.
Need to do this in one formula. I'm trying to 'copy' this formula into a calculated Sharepoint list.
Thanks!
Bookmarks