Transformation of Date

Hi,

I have a issue with several dates that I receive from a macro with numeric format. Then, When I want to transform to string format in matlab, the date doesn't keep the original format.

For example:

12/03/11 05:04:30 --> num --> datestr(num,'dd-mm-yy HH:MM:SS')--> 13/03/0111 05:04:30

How can I revolve this issue?

thanks

regards

Answer 1

[Mtlb Usr]

Hi,

Sorry I have confused. The issue is that the number that I get from a macro is in the 1900/01/01 base of date. However, in matlab the base of date is 0000/01/01.

I have to check this difference for resolve the issue.

regards.

[Andreas Goser]

When you "macro" - that is somethin in MS Excel?

[Mtlb Usr]

Hi,

Yes, that is.

regards

Answer 2

[Jan]

Extremely strange. Please edit your question and insert the original code you used for this and mention the Matlab version.

In Matlab 2009a I get:

S = '12/03/11 05:04:30'
num = datenum(S)
datestr(num, 'dd-mm-yy HH:MM:SS')
>> '03-12-11 05:04:30'

The result is as expected. The result you get '13/03/0111 05:04:30' is surprising: where do the '/' come from?!

Answer 3

[Andreas Goser]

Please note the following solution: Why do I see different results when passing dates from Excel into MATLAB?

[Mtlb Usr]

Hi Andreas,

You are right.

I have resolved with a similar solution.

thanks

regards