Code to get date time difference in ax 2012
Views (3711)
SANTOSH KUMAR SINGH
1,224
Like
Share
ReportThis is a sample example to get date time difference in ax 2012
Output will be like this:-7 day, 3 hrs.
I hope it will help you in your date time troubleshooting.
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.
This was originally posted here.
*This post is locked for comments