I have 2 date field in PurchTable is ConfirmDate and POSendingDate.
I want to get result of ConfirmDate - POSendingDate.
Ex: ConfirmDate = 10/07/2013
POSendingDate = 08/07/2013
ConfirmDate - POSendingDate = 2
but the result i have from AX2009 is -41 461. I want to get result is 2 not -41461. How can i do it? Please help me.