Using an update query based on text and date
Posted on 2014-11-10
I have a memo field that might have the following text (mixed in with other text):
PT Notified of DS office
PT Notified of DS office (MM-DD-YY)
PT Notified of DS office (MM/DD/YY)
I would like to remove this from the memo field. I have found a way to do so for the text portion but not the date portion. (Replace [Notes],"*PT Notified of DS office*,"")
Is it possible to something like this and then trim the results when there is a date?