Use a dict item for the field that does not have the date conversion. Usually F1 or F2 or whatever are just raw formatted and will work.
Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Greg Coelho Sent: Tuesday, January 29, 2013 2:38 PM 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
