Hi,
Is it possible to calculate dateDiff like excel in TI or Rules ?
Return string : Nr of Days - Nr Hours - Nr of Minutes - Nr of Seconds
Thank you
DateDiff like excell
-
pobrouwers
- Posts: 34
- Joined: Mon Aug 11, 2008 7:37 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.5.2
- Excel Version: 2003-2007
- Location: France
-
Alan Kirk
- Site Admin
- Posts: 6654
- 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: DateDiff like excell
You have to build your own with a lot of those functions. If you haven't seen this post you might find a browse through it worthwhile.pobrouwers wrote: Is it possible to calculate dateDiff like excel in TI or Rules ?
Return string : Nr of Days - Nr Hours - Nr of Minutes - Nr of Seconds
"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.
-
Harvey
- Community Contributor
- Posts: 236
- Joined: Mon Aug 04, 2008 4:43 am
- OLAP Product: PA, TM1, CX, Palo
- Version: TM1 8.3 onwards
- Excel Version: 2003 onwards
- Contact:
Re: DateDiff like excell
TM1 generally has pretty limited date functionality. The first thing I usually do on a project is create a date lookup cube, with all the date functions I might need.
Flow Server Manager has the ability to include a pretty good date lookup cube when you use it to create a new server. It is indented to help with finding past and future months and years for the most part, but you might find it does what you want or you can extend it to suit your needs.
Alan Kirk's post is excellent, and should be required reading for all TM1 developers. I hadn't seen it before, thanks for the pointer!
Flow Server Manager has the ability to include a pretty good date lookup cube when you use it to create a new server. It is indented to help with finding past and future months and years for the most part, but you might find it does what you want or you can extend it to suit your needs.
Alan Kirk's post is excellent, and should be required reading for all TM1 developers. I hadn't seen it before, thanks for the pointer!
Take your TM1 experience to the next level - TM1Innovators.net