Page 1 of 1
Function that brings back the name of a month
Posted: Mon Jun 25, 2012 2:19 pm
by nholtzsh
Hi All,
Is there a function in turbo that brings back the name of the month (aka: "January", "February" etc.)
Thanks,
N
Re: Function that brings back the name of a month
Posted: Mon Jun 25, 2012 2:22 pm
by jim wood
You have put this in the general section??? What software are you using?
Re: Function that brings back the name of a month
Posted: Mon Jun 25, 2012 2:25 pm
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
Re: Function that brings back the name of a month
Posted: Mon Jun 25, 2012 2:47 pm
by jim wood
Post moved to the Cognos TM1 Forum.
Re: Function that brings back the name of a month
Posted: Mon Jun 25, 2012 3:03 pm
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.
Re: Function that brings back the name of a month
Posted: Mon Jun 25, 2012 3:05 pm
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' )
Re: Function that brings back the name of a month
Posted: Mon Jun 25, 2012 3:18 pm
by jim wood
Thanks for clarifying that Lotsa.
Re: Function that brings back the name of a month
Posted: Mon Jun 25, 2012 3:22 pm
by nholtzsh
Thank you guys, that helps!