Difference between two years

[Wilfred]

My query is



Service: DateDiff("yyyy",([Reg]),#1/1/2020#)

Where "Reg" is registered year (ex. 2004) But I get the reply as 115. The reply should be 15 or suppose 16. " Service" is number of years served up to 1/1/2020.

Please assist to get the correct answer.

Thank you.

Wilfred.

[ArviLaanemets]

2004 as date is 2004 days from 1st January 1905 (26th June 1915). Difference between years 2020 and 1905 is 115. So Access is right there!

[Bob Fitz]

My query is

Service: DateDiff("yyyy",([Reg]),#1/1/2020#)

Where "Reg" is registered year (ex. 2004) But I get the reply as 115. The reply should be 15 or suppose 16. " Service" is number of years served up to 1/1/2020.

Please assist to get the correct answer.

Thank you.

Wilfred.

Something like:

 Service: 2020-[reg]

If you want it to work next year (2021) and subsequent years then:

Service: Year(Date())-[reg]

[isladogs]

2004 as date is 2004 days from 1st January 1905 (26th June 1915). Difference between years 2020 and 1905 is 115. So Access is right there!

However Access dates are counted from 30 Dec 1899 not 1 Jan 1905 so I don't think that makes sense. Perhaps you could explain

[ArviLaanemets]

However Access dates are counted from 30 Dec 1899 not 1 Jan 1905 so I don't think that makes sense. Perhaps you could explain

Sorry, a typo there as I was distracted!

[Cottonshirt]

if you want to calculate how many years have elapsed between the year represented by your 4-digit number [reg], and today,

1. convert [reg] into a valid date by using the DateSerial() function: = DateSerial([reg],1,1)

then use the DateFiff() function to calculate how many years there are between that date, and today,

      DateDiff("yyyy",DateSerial([reg],1,1),Date())

many thanks,


Cottonshirt