Convert Excel date
bobs at twft.com
Thu Dec 15 12:14:18 EST 2011
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 Mac. Windows uses Visual Basic, and I don't have the foggiest clue about that, except to say that to launch a visual basic script saved as a file on the hard disk, you can use a shell command:
If you know Visual Basic and they have a conversion for dates, you can give that a shot.
On Dec 15, 2011, at 2:29 AM, Ludovic Thébault wrote:
> 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:
More information about the Use-livecode