Re: Convert Excel date

2011-12-16 Thread Peter M. Brigham, MD
> > -Original Message----- > From: Ludovic Thébault > To: How to use LiveCode > Sent: Thu, Dec 15, 2011 12:31 am > Subject: Convert Excel date > > > Hello, > > I've a csv file created by excel. >

Re: Convert Excel date

2011-12-16 Thread Ludovic Thébault
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

Re: Convert Excel date

2011-12-15 Thread dunbarx
o: How to use LiveCode 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 ! _

Re: Convert Excel date

2011-12-15 Thread Curry Kenworthy
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

Re: Convert Excel date

2011-12-15 Thread Bob Sneidar
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

Convert Excel date

2011-12-15 Thread Ludovic Thébault
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