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