AnsweredAssumed Answered

Finding 'Dates' Using Wildcards and Full Stops

Question asked by leedsman on Jan 28, 2012
Latest reply on Jan 31, 2012 by leedsman

Title

Finding 'Dates' Using Wildcards and Full Stops

Post

 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. 

Outcomes