CRM On Demand - Administration (MOSC)

MOSC Banner

Calculate difference between two dates

edited Apr 13, 2011 6:46AM in CRM On Demand - Administration (MOSC) 1 commentAnswered
Hi,

Here is what i want to achieve.

Calculate the difference between to 2 dates and display it in hours by updating a field.

i have used workflow to update the field.

This is the expression i have used WF Action Step Update Field

Timestamp()-[<Last_Changed_on>] , but the result value displays in this format "0.002233796296296"

How do i convert this to Hr or Minutes and display it in field

 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center