calculating date difference

asembereng
Member Posts: 220
I have two different dates; date of birth and dead date, i need to calculate the difference and using that figure to calculating how much benefits should be paid, how can i do this please?
0
Comments
-
By subtracting Date1 from Date2 you will get an integer with the number of days.
Age is Variable type IntegerAgeInDays := "DeathDate" - "BirthDate";
Your code might look something like this.
If AgeInDays >= "YourSpecificBreakdown" then
BenefitAmount := Something
Else
BenefitAmount := Something Else
See This post for more code
http://www.mibuso.com/forum/viewtopic.php?t=10081
You can always divide by 365.2364 to get it to Years.
You can adjust the code like this since days since last birthday is not what you're looking for.“Birth Date” - OnValidate IF "Birth Date" <>0D THEN BEGIN AgeInDays:= "Death Date" -"Birth Date" ; //Returns number of days old AgeInYears:=(Age/365.2364); //Returns number of years old as Decimal - Takes into Account Leap Years i:= STRPOS(FORMAT(AgeInYears),'.'); IF i>0 THEN Agestr:= COPYSTR(FORMAT(AgeInYears),1,i-1) //Return no of years old as string – removes decimal value ELSE Agestr:= FORMAT(AgeInYears); //Return no of years old as string END;
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