To be explicit, I think you'll have to create a dictionary item. I don't know how to do a date conversion with spaces removed using a single date conversion function/format. Something on my wish list...
(UniData) - of course the second conversion could be in attribute 3. 001: V 002: DATE;OCONV(@,'D4MDY');OCONV(@,'MCN') 003: 004: Date 005: 8R 006: S Karjala >>> [EMAIL PROTECTED] 06/10/2004 11:27:27 AM >>> Could you double-convert? Convert via D2/ or D4/ to start, then MCN to remove the symbols. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S Sent: Thursday, June 10, 2004 8:21 AM To: U2 USERS Subject: [U2] Date Conversion Format I am using looking for a date format conversion to use. We are using the format DDMMY which formats the date to "02 10 1970". We are creating an MVQUERY extract and the customer would prefer to eliminate the spaces in the date. Is there another date format conversion that we can use or we do we have to create another dictionary to remove these blanks ? --------------------------------- Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/