Re: How to read in Date from Excel file?

[Markus Bergholz]

On Thu, Dec 19, 2013 at 9:02 AM, lisa_octave <address@hidden> wrote:

Thanks very much for your quick response!

However datestr() didn't return the correct date...

octave.exe> datestr(41267)
ans = 20-Dec-0113

>> datestr(41267)

ans = 25-Dec-0112

I've got this result on Octave 3.6.4, 3.8.0.RC1 and Matlab 2013a

That's realy interesting! What Octave Version are you using?

 

Though if I do datestr(41267,2) it returns 12/20/13.

I think this is because of initial date in Octave? Do you know how to get
the correct year 2013?

you can format the output like that 

>> datestr(41267,'dd.mm.yy')

ans = 25.12.12

 

Thanks again!



--
View this message in context: http://octave.1599824.n4.nabble.com/How-to-read-in-Date-from-Excel-file-tp4660211p4660217.html

Sent from the Octave - General mailing list archive at Nabble.com.
_______________________________________________
Help-octave mailing list
address@hidden
https://mailman.cae.wisc.edu/listinfo/help-octave

--
icq: 167498924
XMPP|Jabber: address@hidden