You need to sign in to do that
Don't have an account?
Baktash H.
Time Difference
Hello,
i have a small problem.
I need to know the difference between 2 datetimes in seconds.
One is a CreatedDate field, the other is datetime.now()
I tried converting them to timestamps to calculate with them but it didn't work.
Anyone have ideas?
Hi developer74,
Did you try convert the two dates to date value and then do the calculation.
Also when you subtract two dates the difference is calculated or returned in days which can be converted into seconds later.
Hope this helps.
thanks for the anser but the conversion does not work.
i tried this:
Integer date1 = DateTime.getTime(myList[0].CreatedDate);
which i took from here:
http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_methods_system_datetime.htm
But it says it does not know the method.
You can directly subtract the one datetime from another. Find below a formula to calculate the total number of minutes from two datetime fields:
Total number of seconds = (LastModifiedDate-CreatedDate)*24*60*60;
actually i tried that.
Integer theNumber = Integer.valueOf(datetime.now()) - Integer.valueof(lastComment[0].CreatedDate);
it give me this nice message:
java.util.GregorianCalendar[time=1322078572979,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=2011,MONTH=10,WEEK_OF_YEAR=47,WEEK_OF_MONTH=4,DAY_OF_MONTH=23,DAY_OF_YEAR=327,DAY_OF_WEEK=4,DAY_OF_WEEK_IN_MONTH=4,AM_PM=1,HOUR=8,HOUR_OF_DAY=20,MINUTE=2,SECOND=52,MILLISECOND=979,ZONE_OFFSET=0,DST_OFFSET=0]