Conversion of String Date to Number

Post Reply
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:
Contact jim wood

Conversion of String Date to Number

Post by jim wood »

Guys,

Am I going daft? does TIMVL only work on time numeric values? How would I go about converting 28-01-2011 (DD-MM-YYYY) in to a numeric value?

Thanks in advance,

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
Top
User avatar
Mike Cowie
Site Admin
Posts: 484
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: IBM TM1/PA, SSAS, and more
Version: Anything thru 11.x
Excel Version: 2003 - Office 365
Location: Alabama, USA
Contact:
Contact Mike Cowie

Re: Conversion of String Date to Number

Post by Mike Cowie »

Hi Jim:

You looking for DAYNO?

http://publib.boulder.ibm.com/infocente ... dayno.html

Slightly different format needed for the date string, but that should get you from a date string to a TM1 numeric date.

Regards,
Mike
Mike Cowie
QueBIT Consulting, LLC

Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
Top
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:
Contact jim wood

Re: Conversion of String Date to Number

Post by jim wood »

After posting I found it. Always the way. I'll get my coat and call a cab..........
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
Top
Post Reply

Return to “IBM TM1, Planning Analytics, PAx and PAW”