computing the difference from a date to now - need integer value.

jeffreyh851 over 8 years ago

I am computing the difference from a date to now and the report is defaulting the result to display 3 days 19 hrs 50 mins when I just need the integer value like "3". Advice?

Discussion posts and replies are publicly visible

Parents

0 reginaldm377 over 8 years ago

You could do something like this - tointeger(now() - date(2016, 08, 15))
(you'll have to change the given dates accordingly) if done in SAIL or in an expression rule. If it's back-end (process model), capture the result in a process variable that is of type Integer so it auto-casts that value into an integer.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 reginaldm377 over 8 years ago

You could do something like this - tointeger(now() - date(2016, 08, 15))
(you'll have to change the given dates accordingly) if done in SAIL or in an expression rule. If it's back-end (process model), capture the result in a process variable that is of type Integer so it auto-casts that value into an integer.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data