Krish, Why don't you just transfer the data to MS Excel already converted? Example. DT=OCONV(FIELD(DATE_Time_Qty,'*',1),'D4/') TM1=FIELD(DATE_Time_Qty,'*',2) TM=OCONV(FIELD(TM1,'.',1),'MT')
You can create a dict or eval item. Hope it helps. Cheers, Angelo From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, August 29, 2006 9:53 AM To: [EMAIL PROTECTED] Subject: [U2] Convert to date and Time I need to convert a Multivalue field to Date and Time format in MS Excel. The Mutivalue filed has the following description and the value next to that. Date_Time_Qty: 14121*31190.858 Any suggestion is appreciated. Thanks. Krish ------- 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/
