Dear all,
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.
Use “date2num()” function.
Thanks,
Nunna
Hi Tommy,
Use date2num function…
For example…
static void Job20(Args _args)
{
date1980 fromdate, todate;
;
fromdate = mkdate(01, 06,2013);
todate = mkdate(10,06,2013);
info(strfmt(’%1’, date2num(todate)- date2num(fromdate)));
}
Dear all,
I was used date2num function but the result still -41 461.
this is my code
info("ConfirmDate - POSendingDate = " + num2str(date2num(purchTable.SKConfirmDateARV) - date2num(purchTable.SKVNPOSendingSKVN),0,16,1,3));
this is the result of code above:
ConfirmDate - POSending = -41 461.0000000000000000
Dear all,
I was used date2num function but the result still -41 461.
this is my code
info("ConfirmDate - POSendingDate = " + num2str(date2num(purchTable.ConfirmDate) - date2num(purchTable.POSendingDate),0,16,1,3));
this is the result of code above:
ConfirmDate - POSending = -41 461.0000000000000000
My field purchTable.ConfirmDate, purchTable.POSendingDate is TransDate type.
Pls give me advice.
Thank you for your support.
Hello my friends,
Who can help me solve this problem? What should I do to solve this problem?
Hi.
If you receive such a result it might be caused by date values. Example:
date d1 = mkdate(15,1,2013);
date d2 = mkdate(17,2,2013);
;
info(strfmt("%1", date2num(d2) - date2num(d1)));
Results in 33.
It doesn’t matter if it’s transdate or any other date EDT.