Function to calculate differens between two dates

dn
Member Posts: 71
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?
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?
0
Comments
-
No there is no standard functionality for that.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
Hi
Setup the Base Calender
using th following to see if it iw a working date or notREPEAT 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 helps0 -
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.0
-
Thx....we use already Base Calender..I'll try with tips from Albertvh0
-
I just learned something new!
[Topic moved from Navision forum to Navision Tips & Tricks forum]Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions