Using the Diff2Dates module to calculate age

[Compositor]

I am using the Diff2Dates code to calculate ages and it is working great. My only problem is that I could really do with being able to calculate an age as of September 1st the current year.

Does anyone know how this is done? Instead of using :

=Diff2Dates("ym",[DOB],Now())

can you change "Now" to just a day and month (eg. 09/01)?

Thanks in advance

 

[fneily]

Please see:

http://www.pacificdb.com.au/MVP/Code/Diff2Dates.htm

Also, please explain that the function you are using is a third party creation and supply the source.

 

[MichaelRed]

use search / advanced search in these fora. key words: Age, DOB, AgeASOf, ...



MichaelRed

 

[Zion7]

You said, "as of sept 1st, current year", that's 3 criteria?
What's wrong with Date()?

And no, last 2 arguments in DateDiff, must be fully qualified date. ...I assume same with Date2Diff?

 

[PHV]

You wanted this ?
=Diff2Dates("ym",[DOB],DateSerial(Year(Now()),9,1))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Compositor]

That's exactly what I needed. Thanks PHV.