I want to convert time interval format into number format

vasanthakumari hariharan

(23●1●1●29) Dec 26 '16, 4:18 a.m.

For eg:,

When i subtract date1- date2 it may results in 5 days. I want to convert this 5 days into number 5, then only i can do further calculation

0 votes

1 answer

4,083 views

0 votes

One answer

Permanent link

Cathy Xu

(390●1●5●15) Dec 26 '16, 7:18 p.m.

You may try Cognos _days_between function:
http://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ca_mdlg.doc/c_btf_days_between.html

1 vote

Your answer

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

rational-insight

× 1,224

Question asked: Dec 26 '16, 4:18 a.m.

Question was seen: 4,083 times

Last updated: Dec 26 '16, 7:18 p.m.

I want to convert time interval format into number format

vasanthakumari hariharan

1 answer

4,083 views

0 votes

One answer

Cathy Xu

Your answer

Follow this question

Question details

Related questions