date

[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

 

[Marshall Barton]

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

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