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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ 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
