Convert Dates

Lamba

Hi Professionals,

How could i get the date differences b\w the Workdate and the Purchase Header"."Posting Date, i tried:


Date1 :=WORKDATE;
Date2 :="Purchase Header"."Posting Date";
Date3 := evaluate(d,Date1-Date2);



Date1's datatype is Date.
Date2's datatype is Date.
Date3's datatype is Date.
On subtracting the value is of integer type

mohana_cse06

how can be difference between two dates be a date?

can you explain with example?

01/02/12 - 01/01/11 = ??

jubeljoy

Create a Integer variable as NoOFDays
Now calculate the same following way

NoOFDays := WORKDATE - Purchase Header"."Posting Date;

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision Classic Client' forum]