Krish I found this old post on comp.databases.pick http://groups.google.com/group/comp.databases.pick/browse_thread/thread/ 2808b1db159fc2e6/a5df053ce372b7e5?lnk=gst&q=internal+data+excel&rnum=1#a 5df053ce372b7e5
Salient excerpt: The base date for Excel for Windows is January 1, 1900 and for Excel on the Mac it is January 1, 1904. (Don't ask me why there is a difference. It's 'cause Bill said so.) So, the conversion factors are 24,837 and 23,375 respectively. So to convert from Excel to Pick internal date you would subtract that factor from the Excel date. To convert from Pick to Excel, simply add the factor to the value in question. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. (817) 804-3598 * [EMAIL PROTECTED] * -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, August 29, 2006 8: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/
