DateDiff() Function

L

ltamisin

Hi to all

Im working in a DateDiff() function right now, my question is how can I get
the total Year, Month and Day ? can you give me the formula on how to get
the total Year, Month and Day.

Field1: 11-05-81
Field2: 31-05-05

DateDiff()
Field3: Total Year
Field4: Total Month
Field5: Total Days

Thanks
 
G

Guest

Datediff will only return 1 calculation dependant on what you specify. You
will therefore have to do 3 calculations for year, month and days difference
and manually work it out yourself.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate difference between to records 3
Query Help! 2
figuring averages in Access 2
multiple counts, same calculated field, different parameters 6
Date() formula problems with DateDiff in Access 2
joining several update queries into one 4
DSum update query with multiple fields 0
Date difference 1

Top