Page 1 of 1
Date Conversion
Posted: Mon Nov 07, 2011 7:58 am
by 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.
Re: Date Conversion
Posted: Mon Nov 07, 2011 9:02 am
by 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.
Re: Date Conversion
Posted: Mon Nov 07, 2011 10:07 am
by viswaraju
thank you lotsaram,
i need in TM1 UI and the conversion should be dynamic.
Re: Date Conversion
Posted: Mon Nov 07, 2011 12:44 pm
by 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.