Dates issue-Help needed<Urgent>

[sathishh.mk]

Hi All,

We have small requirement on dates.
we need to subtract one date minus another date.
Currently we are doing this at Data base level and bringing into TM1.
So instead of that,I need to do this at TM1 end.
Can you please help me on this.

EX: First date:20/11/2011 - second Date: 18/11/2011 = 2 Days.

Environment: TM1 9.5.2,window 2008 Server R2,Oracle 10g.


Thanks in Advance for your help!!!


Regards,
Sathish

[Christopher Kernahan]

Create a dimension with all your dates in it then locate the DIMIX of each date and subtract that.

[fliptop]

DAYNO(2011-11-20) - DAYNO(2011-11-18) = 2

DAYNO('DateString')
A date string in either YY-MM-DD or YYYY-MM-DD format.

[Acc_Moonwalk]

Hi,

Is there any way we can enter dates in the intersection of a cube?

we are trying to enter some dates in the cube cells and try to extract the no of days between source date and target date. How is this possible in TM1?
we have two dimensions one is month dimension having all month elements
second dimension is dates having three elements(Source date, Target date and Days Between)

Dates
Month Source date Target date Days Between
Jan 20-10-2011 25-10-2011 5
Feb 01-10-2011 21-10-2011 20

Many thanks
Naresh

[tomok]

Just like in Excel you can store the serial number for the date in the cube then it's very easy to extract dates. Did you even bother to search the forum before you posted this question? There must be literally hundreds of posts about dates logic in TM1.