Page 1 of 1
DateDiff like excell
Posted: Fri Aug 24, 2012 12:33 am
by pobrouwers
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
Re: DateDiff like excell
Posted: Fri Aug 24, 2012 12:40 am
by Alan Kirk
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
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.
Re: DateDiff like excell
Posted: Fri Aug 24, 2012 8:26 am
by Harvey
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!