I am trying to use the Replace() Function in an update queryto select a specific text string followed by a date. I want the date(s) to bewild or where it will select any date following the specific text. It must keepthe text before the text string and after the date.
Example: in field [StatusComment] = Order Approved File at DCS as of 2/21/2020 Pending Action
I can get Replace([Status Comment], ‘File at DCS as of 2/21/2020’, ‘ ‘) to work just fine resulting in
[StatusComment] = Order Approved Pending Action
What I need is for the date to not be specific i.e.##/##/#### or something of the sort.
Does anyone of any idea of how to select thedesired text string to include whatever date follows in this scenario of theReplace()?