Function that brings back the name of a month

Post Reply
nholtzsh
Posts: 10
Joined: Thu Dec 22, 2011 12:38 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

Function that brings back the name of a month

Post by nholtzsh »

Hi All,

Is there a function in turbo that brings back the name of the month (aka: "January", "February" etc.)

Thanks,
N
User avatar
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 by jim wood »

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
nholtzsh
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

Post by nholtzsh »

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
User avatar
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 by jim wood »

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
User avatar
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 by jim wood »

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.
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
lotsaram
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

Post by lotsaram »

nholtzsh wrote:Hi All,

Is there a function in turbo that brings back the name of the month (aka: "January", "February" etc.)

Thanks,
N
as in
TimSt( Now, '\mmm' )
User avatar
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 by jim wood »

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
nholtzsh
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

Post by nholtzsh »

Thank you guys, that helps!
Post Reply