Convert Excel date
dunbarx at aol.com
dunbarx at aol.com
Fri Dec 16 00:17:44 EST 2011
The following is very verbose. I just want you to be able to follow one possible method step by step. Read up on all the commands in the dictionary. Put a breakpoint near the beginning.
on mouseup
convert the date to seconds
put "40892" & "," & it into baseLine
ask "Enter excel date"
put it - item 1 of baseLine into dayOffset
put dayOffset * 86400 into newSeconds
add newSeconds to item 2 of baseLine
convert item 2 of baseline to date
answer item 2 of baseLine
end mouseup
Craig Newman
-----Original Message-----
From: Ludovic Thébault <ludovic.thebault at laposte.net>
To: How to use LiveCode <use-livecode at lists.runrev.com>
Sent: Thu, Dec 15, 2011 12:31 am
Subject: Convert Excel date
Hello,
I've a csv file created by excel.
Dates are displayed in numbers. (1/01/1900 = 1 so today = 40892)
Is there a script to convert it in a real date with livecode ?
Thanks !
_______________________________________________
use-livecode mailing list
use-livecode at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
More information about the use-livecode
mailing list