0

kindly let me know the coding for difference between two dates in the format years, months and days for calculation of qualifying service.
let date of joiningas 19-101983
date of retirement is 30-09-2008
then total qualifying service ? how it will be caculated through coding in visual basic

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by QVeen72
0

Hi,

Use DateDiff function:

dim t as integer
t = DateDiff("d",cdate("19-10-1983"),cdate("30-09-2008"))

You will get difference in Days,
Replace d with yyyy for years
m for month..

OR divide t by 12 to get years..

Regards
Veena

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.