Greg:
Can you do something like:
:select {FileName} WITH EVAL "OCONV(MPAR.STATUS.DATE, 'D')" = ""
This works fine on UniData in PICK mode, where an invalid conversion
returns a null (an empty string).
HTH,
Bill
------------------------------------------------------------------------
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Greg Coelho
Sent: Wednesday, 30 January 2013 8:38
To: [email protected]
Subject: Re: [U2] Searching for 'Bad' Dates
All,
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?
Thanks,
Greg
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
