Simpler is this:
put "1/01/1900" into d
convert d to dateitems
add 40892 to item 3 of d
convert d to short date
put d
-- Peter
Peter M. Brigham
pmb...@gmail.com
http://home.comcast.net/~pmbrig
On Dec 15, 2011, at 10:17 PM, dunb...@aol.com wrote:
> The following is very verbose. I just want yo
Thanks for your help !
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
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"
p
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 ?
I'm working on an Excel importer library, so I've been doing dates as
well. Date conversion and Excel-style date/number formatting options are
needed anyway behind
Search the archives. I think Sarah wrote a julian date converter, but the
problem is that the Julian date can mean several things depending on the
source. Can you have Excel display the date as international format? Otherwise,
I bet there is an Applescript you can use if you are doing this on a
