Small and medium business | Business Central, N...

Calculate difference between two dates?

(0) Share

Report

Posted on by navision begginers

387

Dear Experts,

I have customized the new page, name is 'Purchase Line Details'. Here I have calculated the the PO approval date. it is working fine. Now, I want to make a difference between indent date and PO approval date....my code is giving the below error. Please help me to short it.

OnAfterGetRecord()

CLEAR(dtApproval);
ApprovalEntry.RESET;
ApprovalEntry.SETRANGE(ApprovalEntry."Document No.","Document No.");
IF ApprovalEntry.FINDLAST THEN BEGIN
AppID:=ApprovalEntry."Approver ID";
dtApproval:=ApprovalEntry."Approval Date-Time";
END;

dtApprove:=DT2DATE(dtApproval); //(conversion date time to date field)

dateDifference:=(dtApprove)-("Requisition Date");

when i try to run my customized page...it is showing the below error...

All responses (4)

Answers (0)

navision begginers 387 on at

Like (0)

Report

RE: Calculate difference between two dates?

i have already tried...but still getting the same error messages. please help me to resolve it.
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Calculate difference between two dates?

Put an if condition like below

if dtApprove <> 0D then begin

dtApprove:=DT2DATE(dtApproval); //(conversion date time to date field)

dateDifference:=(dtApprove)-("Requisition Date");

end;
navision begginers 387 on at

Like (0)

Report

RE: Calculate difference between two dates?

Yes, your are right. Most of the documents, dtApprove and 'Requisition Date' are blank in purchase line. what should i do sir. Please help me to resolve it.

Thanks in advance for any help you're able to give with this.
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Calculate difference between two dates?

Please make sure you have the value in dtApproval and also in dtApprove before you calculate the difference.