DateDiff

[Rixxe]

Well it includes the few things you wanted:


Start and end dates (DOB and Today())
Ability to show: Year Month and Day

It should also be very accurate (which is a main problem as you mentioned when doing this sort of query.

I'm sure there are sites out there that will supply code you need, just keep looking and trying different things... i'm sure you will get there at some point.

Best regards.

Rixxe

[mrkaye]

You have done alot and i'm going to try them all.
will let you know as soon as i get it working
Thanks Again
Marty

[mrkaye]

Thanks Rixxe and everyone else who helped with problem.
It is working I used a funchtion with two dates input called date1 and date2 and modifyed it with DOB and now. Works great. Problem solved.
funnction came from, Copyright 2001 Pacific Database Pty Limited
' Graham R Seach MCP MVP gseach@pacificdb.com.au
Thanks again
Marty

[Rixxe]

Well done, nice to see you got it working.
If you could mark this thread as solved that would help greatly.

Good luck in any future projects.


Best regards

Rixxe.