How to get difference between given range of date

Finance and Operations/AX Developer Forum
1

hi,

i have

FromDate— 15/1/2014

FromHour — 23hr

FromMin – 15min

ToDate – 10/2/2014

ToHour — 10hr

ToMin – 15min

How to get the difference between this range.

i need output as

Jan—16 days 1 Hours

feb-- 9 days 10 Hours

Thanks in advance

2

Hi Anil,

Do you need to find these time and date differences in mass? A solution that would handle this would be Foxtrot, using the formula actions. It would allow you to scrape the required information, do the calculation and input that result wherever you would need it to go.

Just let me know if you would like to discuss further.

Regards,

Larry

3

If you don’t want to calculate it by yourself or by DateTimeUtil::getDifference(), use System.DateTime. For example:

System.DateTime fromDate = new System.DateTime(2014, 1, 15, 23, 15, 0);
System.DateTime toDate = new System.DateTime(2014, 2, 1);
System.TimeSpan diff = toDate.Subtract(fromDate);
info(diff.ToString());