Convert Dates

Lamba · 2012-03-31

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 · 2012-03-31

how can be difference between two dates be a date?

can you explain with example?

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

jubeljoy · 2012-03-31

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

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

kriki · 2012-04-01

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

Convert Dates

Comments

Categories