Convert Excel date

Bob Sneidar 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:

cscript.exe "myScript.vbs" 

If you know Visual Basic and they have a conversion for dates, you can give that a shot. 

Bob


On Dec 15, 2011, at 2:29 AM, Ludovic Thébault wrote:

> 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