date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to calculate the different between date of birth and further date
Example for what I am using
14/12/1997 and further date 1/10/2006
Year =DateDiff("yyyy";[geburtsdatum];"1/10/2006") 9
Month =Month("01/10/2006")-Month([geburtsdatum]) -2
Day =Day([geburtsdatum])-Day("1/10/2006") 13

-2 should be 12 I need help please
 
Gur said:
I need to calculate the different between date of birth and further date
Example for what I am using
14/12/1997 and further date 1/10/2006
Year =DateDiff("yyyy";[geburtsdatum];"1/10/2006") 9
Month =Month("01/10/2006")-Month([geburtsdatum]) -2
Day =Day([geburtsdatum])-Day("1/10/2006") 13

-2 should be 12 I need help please
Click to expand...


Maybe you want to use his function:
http://www.accessmvp.com/djsteele/Diff2Dates.html

or maybe this article will give you some ideas:
http://www.mvps.org/access/datetime/date0001.htm
 
Back
Top