Function to calculate differens between two dates

dn · 2007-03-02

I need help to calculate number of days between two dates and just only
ordinary working day should take cares.
Say I have "Posting Date" and "Requested Receipt Date". I want to know how many days it's between them and no holiday involve.
I know u can use (DiffReq := "Posting Date" - "Requested Receipt Date") but it don't care if there is holiday between;

Is there any function in Navision who support the calculation and which codeunit?

kriki · 2007-03-02

No there is no standard functionality for that.

Albertvh · 2007-03-02

Hi

Setup the Base Calender

using th following to see if it iw a working date or not

REPEAT
  WorkingDay := NOT CalendarMgt.CheckDateStatus(ServMgtSetup."Base Calendar Code",
                                                DateStart,Description);
  IF lWorkingDay THEN BEGIN
     ....
  END;

  DateStart := DateStart + 1;
UNTIL DateStart > DateEnd;

Where
CalendarMgt is Codeunit Calendar Management
WorkingDay is boolean
DateStart & DateEnd are your dates
Description is Text 100
ServMgtSetup is Record Service Mgt. Setup

Hope this helps

kine · 2007-03-02

You can look into CU 7600 into function CalcDateBOC which is something like CALCDATE function but using calendar to skip non-working days. You can see there how to find if the day is workday or not (CheckCustomizedDateStatus). You need to go through Date table filtered for the dates between your limits and count all working days.

dn · 2007-03-02

Thx....we use already Base Calender..I'll try with tips from Albertvh

kriki · 2007-03-02

I just learned something new!

[Topic moved from Navision forum to Navision Tips & Tricks forum]

Howdy, Stranger!

Quick Links

Categories

Function to calculate differens between two dates

Comments