Finding 'Dates' Using Wildcards and Full Stops
I am trying to find data which 'looks like' a date in a text field.
I can do this when using the Find button by inputting @@.@@.@@ in the text field, and then hitting the 'Perform Find' button.
However, I cannot replicate the results when setting up a calculation field. I have tried various formats such as "@@.@@.@@" or @@ & "." & @@ & "." & @@ but with no suceess. It is probably very simple, so any help much appreciated. Thanks, Stephen.