Apex Code Development You need to sign in to do that
Don't have an account?
iqbal Subtract Date/Time fields
Hi,
I created a formula field of type number which subtracts two date/time fields and i am getting strange result when two values are subtracted.
(12/24/2009 3:05 PM) - (12/24/2009 12:05 PM) is giving me 0.1250
I basically want to calculate difference between two date/time fields and i expect the difference to be in terms of 'days-months-hours-minutes'.
Has anyone faced this problem? If not with formula field, is there any other way to achieve this.?
thanks,
Asif
The result that is being displayed is the difference in Days: 3 Hours = 0.125 Days. What exactly do you want you formula to display? the time? just hours? HH:MM? HH:MM.SS?
iqbalThanks for your reply. HH:MM is good for me.