Date Conversion

[viswaraju]

Hi,
please give me tips for converting date,
the data format is like
12/02/2011
13/02/2011
DD MM YYYY format and it should be converted into February.

TM1 9.5
Excel 2003.

[lotsaram]

You haven't said in which UI you want to do this!

If it is within Excel then you can achieve this either with cell formatting or else wrapping the value in the Text formula with "MMMM" as the string format.

If within a TM1 UI then you can use a string attribute to hold the month against the date element.

[viswaraju]

thank you lotsaram,
i need in TM1 UI and the conversion should be dynamic.

[Steve Rowe]

Hi,
There is an extensive section on using dates and time here
http://www.tm1forum.com/viewtopic.php?f=21&t=2441

Can I ask that you read this? It ought to contain the answer to your question.
Post locked.