Or alternatively, Bring back the data normally with a D4/ conversion. Create a local formula column to remove the slashes on the client.
Regards, Brian On Thu, 10 Jun 2004 15:04:18 -0700 (PDT) Dave S <[EMAIL PROTECTED]> wrote: >Thanks, we'll see if Mvquery lets me do that. >--- Dana Baron <[EMAIL PROTECTED]> wrote: >> 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/ > > > > > >__________________________________ >Do you Yahoo!? >Friends. Fun. Try the all-new Yahoo! Messenger. >http://messenger.yahoo.com/ >------- >u2-users mailing list >[EMAIL PROTECTED] >To unsubscribe please visit http://listserver.u2ug.org/ > >________________________________________________________________________ >This email was checked by MessageLabs SkyScan before entering Microgen. ________________________________________________________________________ This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
