When i feed an excel sheet with data from UniVerse via a perl script i use the
well known format :
$worksheet->write_date_time('A1', '2004-05-13T23:20', $date_format);
i use this routine in my basic program :
******************************************************************
CONVERT.DATO:
******************************************************************
*
* Convert date to a format understood in date formatted columns in EXCEL
* after the 'T' you can apply the time in HH:MM notation
*
* input : I.DATO : i.e. : 14192
* : I.TIME : i.e. : 34567.334
* output : O.DATO : i.e. : 2006-11-08T
O.DATO = OCONV(I.DATO,'D4-YMD'):'T'
* with time added
* O.DATO = OCONV(I.DATO,'D4-YMD'):'T':OCONV(I.TIME,'MTS')
RETURN
In your case the line would be :
O.DATO =
OCONV(FIELD(Date_Time_Qty,'*',1),'D4-YMD'):'T':OCONV(FIELD(Date_Time_Qty,'*',2),'MTS')
Best regards from denmark
Claus Derlien
programmxr
Edb-afdelingen
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
> Sent: Tuesday, August 29, 2006 3:53 PM
> 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/
