am trying to get difference between to given date and time. Am using calworkdays

nimishan over 10 years ago

am trying to get difference between to given date and time. Am using calworkdays function to acheive this however the output the output is given as number i want to display in the form of days ,hours and minutes format.Please give suggestion....

Discussion posts and replies are publicly visible

Top Replies

Malathi over 10 years ago +1
Certified Lead Developer

You can try the below expression which returns output as days,hours and minutes. with(a:ri!date2-ri!date1,b:split(a,":"),b[1]&" days,"&b[3]&" hours,"&b[4]&" minutes")

Parents

0 Malathi
Certified Lead Developer
over 10 years ago

You can try the below expression which returns output as days,hours and minutes.
with(a:ri!date2-ri!date1,b:split(a,":"),b[1]&" days,"&b[3]&" hours,"&b[4]&" minutes")
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Malathi
Certified Lead Developer
over 10 years ago

You can try the below expression which returns output as days,hours and minutes.
with(a:ri!date2-ri!date1,b:split(a,":"),b[1]&" days,"&b[3]&" hours,"&b[4]&" minutes")
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data