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:
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
The number before the asterisk is the date stored as the number of days
since 12/31/1967 (so day 14121 = 08/29/2006).
The remaining number is the number of seconds (and thousandths of
seconds) since midnight. In this case 08:39:50am
[EMAIL PROTECTED] wrote:
I need to convert a Multivalue
Do you mean something like this:
SUBR(-FIELDS, Mv_Dict, , 2);
SUBR(-FIELDS, @1, *, 1);
SUBR(-FIELDS, @1, *, 2);
SUBR(-FIELDS, @, ., 1);
OCONVS(@2, D2/);
OCONVS(@4, MTH);
SPLICE(@5, , @6)
Thanks,
David A. Green
DAG Consulting
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
Krish
I found this old post on comp.databases.pick
http://groups.google.com/group/comp.databases.pick/browse_thread/thread/
2808b1db159fc2e6/a5df053ce372b7e5?lnk=gstq=internal+data+excelrnum=1#a
5df053ce372b7e5
Salient excerpt:
The base date for Excel for Windows is January 1, 1900 and for