Subtracting Dates from Dates

[Joseph31]

How do I subtract a date from a date and get an answer by Years / Months / Days.

Example:

1-1-04 subtracted from 8-1-05 returns

1 year 7 months 0 days

Thank you,

Joseph

[fmp6andfmp7]

Example:

1-1-04 subtracted from 8-1-05 returns

1 year 7 months 0 days

[sbg2]

to get the year you would:

(right(date2, 2))-(right(date, 2)

and so on with the day and month then recombine.

Try testing that with dates such as:

date1 = 11-1-04 , date2 = 1-1-05

date1 = 1-13-05 , date2 = 2-1-05

date1 = 1-1-99 , date2 = 1-1-01

To get the year of a date field = Year(date1)

[-Queue-]

How do you define months?

[Joseph31]

Ok I know I should Understand all of that but I really do not... I have tried the example does not work the way I thought it would. Any other help on this subject would be very helpful.

Thanks,

Joseph

[comment]

In this thread you will find both the formula and the explanation to Queue's remark.

[Joseph31]

Thank you,

I would have never have figured this out without that.

Thank you,

Joseph