slick - i new about the multi conversions seperated by @VM but i didn't know you could pack the date conversions together like that
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stevenson, Charles Sent: Wednesday, October 12, 2005 06:38 PM To: [email protected] Subject: RE: [U2] Date Conversion Codes And just for jollies here are some others that are sorta like what you want: DICT <3>............. DICT <5>....... Result..................... DWAMADY 30L WEDNESDAY SEPTEMBER 14 2005 DWAMADY}MCT 30L Wednesday September 14 2005 DWAMADY[3,3,2,4] 15R WED SEP 14 2005 DWAMADY[3,3,2,4]}MCT 15R Wed Sep 14 2005 DWAMADY[3,3,2,4]}MCT 19R#3.,#4.#3,#5 Wed., Sep. 14, 2005 ^ /|\ | | The "}" is a value-mark. Did we know we could have multiple conversions, separated by value marks? Could probably tack an A or F conversion/correlative code in there, too. My favourite is to get CCYYMMDD format by date conversion, then Mask-Character-Numeric to strip out the delimiters: 01 D some date field, output as CCYYMMDD 02 nnn 03 DYMD[4,2,2]}MCN 04 05 8R Or in basic: CCMMYDD = OCONV( Idate, 'DYMD[4,2,2]':@VM:'MCN' ) ^^^^^ ------- 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/
