Skip to main content

Posts

Showing posts with the label day hours min difference

Code to get date time difference in ax 2012

This is a sample example to get date time difference in ax 2012 TransDateTime dateTime_a, dateTime_b; date date1, date2; int64 c; #define.NoOfHrsInADay(24); dateTime_a= 2014-09-26T11:59:59; dateTime_b= 2014-09-19T08:50:50; c = DateTimeUtil::getDifference(dateTime_a,dateTime_b); date1 = DateTimeUtil::date(dateTime_a); date2 = DateTimeUtil::date(dateTime_b); c = c - (date1-date2)*(#NoOfHrsInADay)*60*60; info(strFmt("%1 day, %2 hrs.",(date1-date2), c div 3600)); Output will be like this:-7 day, 3 hrs. I hope it will help you in your date  time troubleshooting.