Bill, This is only returning those records that do not have a value in MPAR.STATUS.DATE. Unfortunately I looking for records where an external date has been written instead of the internal date.
Greg From: Bill Haskett <wphask...@advantos.net> To: U2 Users List <u2-users@listserver.u2ug.org> Date: 01/29/2013 06:01 PM Subject: Re: [U2] Searching for 'Bad' Dates Sent by: u2-users-boun...@listserver.u2ug.org 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: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, 30 January 2013 8:38 To: u2-users@listserver.u2ug.org 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users