Sunday, August 28, 2016

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.