Or CONVERT " " TO "" IN DATE.VAR (The first set of quotes has a blank, the second does not).
Dana Baron System Manager Smugglers' Notch Resort -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin King Sent: Thursday, June 10, 2004 11:27 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Date Conversion Format 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/
