Calculate Date

Dynamics 365 Business Central/NAV User Forum
1

Hi Professionals,

I need to calculate Due Date from field which is Dateformula Type and WORKDATE

Due Date =WORKDATE + LeadTimeCalculation(type:date formula)

But this line is not possible in navision ( I got errors). So , I try with conversion dateformula to date

LeadTimeTxt := FORMAT(ItemVendor.“Lead Time Calculation”);

EVALUATE(LeadTimeDate,LeadTimeTxt);

DueDate := WORKDATE + LeadTimeDate;

But there is still error

“Type conversion is not possible because 1 of the operators contains an invalid type.”

Date + Date

So, can somebody tell me how can I handle with this because I am new in navision and this is confusing for me

I need general rule for calculating data from 2 date fields( DATE = DATE + DATE)

Thanks in advance

2

Did you try

DueDate := CALCDATE(LeadTimeCalculation,WORKDATE);

3

CSDIE Reference (or the msdn version Microsoft Dynamics NAV 2009 Developer and IT Pro Documentation) guide is your friend :wink:

CALCDATE