Hi All,
Is there a function in turbo that brings back the name of the month (aka: "January", "February" etc.)
Thanks,
N
Function that brings back the name of a month
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Function that brings back the name of a month
You have put this in the general section??? What software are you using?
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 10
- Joined: Thu Dec 22, 2011 12:38 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
Re: Function that brings back the name of a month
Ooops, you are absolutely right my bad.
I'm using TM1 version 9.0.0 but there is a possibility of upgrading to 9.5.2 if that helps
Thanks!
N
I'm using TM1 version 9.0.0 but there is a possibility of upgrading to 9.5.2 if that helps

Thanks!
N
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Function that brings back the name of a month
Post moved to the Cognos TM1 Forum.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Function that brings back the name of a month
To answer your question. There is set of time functions for rules. If you use a combination of both NOW and TIMST you'll be able to get you what you need. You'll find these functions in the TM1 reference guide in the TM1 documentation that comes with your install,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Function that brings back the name of a month
as innholtzsh wrote:Hi All,
Is there a function in turbo that brings back the name of the month (aka: "January", "February" etc.)
Thanks,
N
TimSt( Now, '\mmm' )
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Function that brings back the name of a month
Thanks for clarifying that Lotsa.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 10
- Joined: Thu Dec 22, 2011 12:38 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
Re: Function that brings back the name of a month
Thank you guys, that helps!