How about a DICT item that performs a match like "2n'/'2n'/'2n" on that field?

-----Original Message-----
[] On Behalf Of Greg Coelho
Sent: Wednesday, 30 January 2013 8:38
Subject: Re: [U2] Searching for 'Bad' Dates


Can anyone help me with a query to find instances where an external date has 
been written to a date field?  I would like to use ...WITH MPAR.STATUS.DATE 
LIKE "..
./..." (the dates would be in the fomat: '12/16/12', but this field is set with 
external formatting so I end up bringing back everything.  Is there a way I can 
'turn off' formatting for this field within the query?


U2-Users mailing list

This email (inc all attachments) is for the use of the intended recipient(s) 
Privileged or confidential information may be contained in this communication. 
If you have received this email in error, please notify the sender immediately 
and then delete all copies of this message from your computer network. If you 
are not the intended recipient, you must not keep, use, disclose, copy or 
distribute this email without the author's prior permission. If you are the 
intended recipient and you do not wish to receive similar electronic messages 
from us in future, then please respond to the sender to this effect. 
We have taken precautions to minimise the risk of transmitting software 
viruses, but advise you to carry out your own virus checks on this email and 
its attachments. We do not accept liability for any loss or damage caused by 
software viruses and do not represent that this transmission is free from 
viruses or other defects. 
Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) 
U2-Users mailing list

Reply via email to