How to find difference between two utcdatatime field in the form of hours, min, sec?

(0) Share

Report

Posted on by akshaykupra

516

Hello,

i am stuck with this small problem that how to represent seconds in the form of days, hours, min, sec. means i am trying to find difference between two utcdatetime field so i tried this

mytime = datetimeutil::getDifference(MouldInfoTable.CreateDT,MouldInfoTable.CloseDT);

from this i get difference in the seconds form, but i dont know how to do in above form, i tried google but it is not working. if is there any solution apart from that or any mathod , please share,

Thanks

akshay

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Pravasti AK 2,985 on at

Like (0)

Report

Hi,

To calulate the difference in hours mins and seconds use this function DateTimeUtil :: getDifference but for example if you want to get the different in mins you have to divide the value from that function on 60 and so on.To calculate the difference in days weeks months years use this function intvNo(toDate, fromDate, intvScale::YearMonthDay) and change intvScale enum depending on the difference type day month year.

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report
Hi akshaykupra,

You can use this code to convert seconds to days, hours, minutes and seconds:

info(strFmt('%1d:%2h:%3m:%4S', (mytime div 86400), ((mytime Mod 86400) div 3600), ((mytime Mod 3600) div 60), ((mytime Mod 3600) Mod 60)));

Was this reply helpful? Yes No
akshaykupra 516 on at

Like (0)

Report

Hi,

@ievgen : thank you so much, this is what i am looking for.

@Kavitha : thank you for explaining and same thing done above.

Thanks,

Akshay

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

Try the DateTimeUtil::getDifference Method to get the number of seconds between two specified utcdatetime values. See: msdn.microsoft.com/.../datetimeutil.getdifference.aspx

days = DateTimeutil::getDifference(DateTime123, DateTime234) / #secondsPerDay;

Also see this useful reference post sujanadynamics.blogspot.ae/.../date-calculations.html

Was this reply helpful? Yes No