21 Aug 2014

Difference between two dates + AX 2012

You have a grid where you can select the StartDate and the EndDate of the vacation, and you have a field for the calculation of the differnce in days between these two fields:



You can override the method leave  and use this code for example to calculate the diffrence:
public boolean leave()
{
Boolean ret;
StartDate inputDate;
EndDate refDate;
ret = super();

inputDate = str2Date(strFmt("%1",TestTable.StartDate), 123);
refDate = str2Date(strFmt("%1",TestTable.EndDate), 123);
TestTable.Hours=intvNo(refDate, inputDate, intvScale::YearMonthDay);
return ret;
}

No comments:

Create number sequence in D365 FO

Create the data type. Add code in the loadModule method of the appropriate NumberSeqModule subclass. Add a method to the module’s paramet...