Thread Subject:

numbers to dates

Hi there,
How to convert numbers to dates. In the below 10321 is based on format of ymmdd which means 21/03/2001 and 1100 means 11:00:00.

input = [10321 1100;10322 1200;10323 1300]
output= {'21/03/2001 11:00:00';'22/03/2001 12:00:00';'23/03/2001 13:00:00'}

On 18 apr, 10:31, enviro <farhadnejadkoo...@yahoo.co.uk> wrote:
> Hi there,
> How to convert numbers to dates. In the below 10321 is based on format of ymmdd which means 21/03/2001 and 1100 means 11:00:00.
>
> input = [10321 1100;10322 1200;10323 1300]

1) Extract dates, months and years from the number (Hint: The
   numbers always appear in the same order. Divide by 100 to
   move the 3rd digit to an easy-to-reach position.)
2) Use SPRINTF to reassemble the numbers on the desired format
3) Repeat for times.

And I wouldn't be surprised if something like DATESTR already
can do what you want.

Rune

Could you give me an example?

enviro wrote:
> Could you give me an example?

Could you show us what you've tried to do to implement one of Rune's
most excellent suggestions as to how to proceed?

--

dpb wrote:
> enviro wrote:
>> Could you give me an example?
>
> Could you show us what you've tried to do to implement one of Rune's
> most excellent suggestions as to how to proceed?

Oh, and one more possibility to add to his list --

Convert to a character array and then parse it w/ (say) strread() and
let the rtl i/o library handle the scaling via judicious use of
formatting string(s).

num2str() might be useful here, in the first step...

It would seem wrapping this into a function would be _a_good_thing_ if
this occurs more than just once't or twice.

--