Trying to get a TI to run on a specific day every month and I'm getting some strange behaviour
It seems that DayNo gives tomorrow not today
asciioutput( 'temp.cma' , Today, Str(DayNo(Today),2,0) );
Contents of temp.cma
"09-07-17","18"
That has to be a bug? Or is this some kind of feature?? All the code has to do is right(date,2) not too much to ask is it??
vers 9.0.3 U9
Possible bug with Today and Day TI functions
- Steve Rowe
- Site Admin
- Posts: 2455
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Possible bug with Today and Day TI functions
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Site Admin
- Posts: 6645
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Possible bug with Today and Day TI functions
Uh, Butch? Y'sure it's "DayNo" (which returns the serial number) that you want there and not "Date" (which returns the date string)?Steve Rowe wrote:Trying to get a TI to run on a specific day every month and I'm getting some strange behaviour
It seems that DayNo gives tomorrow not today
asciioutput( 'temp.cma' , Today, Str(DayNo(Today),2,0) );
Contents of temp.cma
"09-07-17","18"
That has to be a bug? Or is this some kind of feature?? All the code has to do is right(date,2) not too much to ask is it??
vers 9.0.3 U9
(I know, it's Friday and it's been a long week...

Regards, Sundance.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Site Admin
- Posts: 6645
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Possible bug with Today and Day TI functions
Actually for me as well; I think that since you're already getting the date string from Today(), you may as well just use SubSt to parse it. Raising the bridge rather than lowering the river and all....Alan Kirk wrote:Uh, Butch? Y'sure it's "DayNo" (which returns the serial number) that you want there and not "Date" (which returns the date string)?Steve Rowe wrote:Trying to get a TI to run on a specific day every month and I'm getting some strange behaviour
It seems that DayNo gives tomorrow not today
asciioutput( 'temp.cma' , Today, Str(DayNo(Today),2,0) );
Contents of temp.cma
"09-07-17","18"
That has to be a bug? Or is this some kind of feature?? All the code has to do is right(date,2) not too much to ask is it??
vers 9.0.3 U9
(I know, it's Friday and it's been a long week...)
Regards, Sundance.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- Steve Rowe
- Site Admin
- Posts: 2455
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Possible bug with Today and Day TI functions
Doh, yes it's me...
Already switched to subst.
asciioutput( 'temp.cma' , Today, Str(Day(Today),2,0) );
Is what I was after.
It's just one of those horrid conincidences that the serial number for 17/07/2009 happens to end with 18 that led me up the garden path.
{Evil thought : Might report it to IBM support and see how long it takes them to fix!}
Already switched to subst.
asciioutput( 'temp.cma' , Today, Str(Day(Today),2,0) );
Is what I was after.
It's just one of those horrid conincidences that the serial number for 17/07/2009 happens to end with 18 that led me up the garden path.
{Evil thought : Might report it to IBM support and see how long it takes them to fix!}
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Site Admin
- Posts: 6645
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Possible bug with Today and Day TI functions
Based on one recent thread, they'll probably tell you to move the code to the Data tab and see whether that works...Steve Rowe wrote:Doh, yes it's me...
Already switched to subst.
asciioutput( 'temp.cma' , Today, Str(Day(Today),2,0) );
Is what I was after.
It's just one of those horrid conincidences that the serial number for 17/07/2009 happens to end with 18 that led me up the garden path.
{Evil thought : Might report it to IBM support and see how long it takes them to fix!}

"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.