date calculation on a report

[Mark]

Hello all,

I have a report with a text box that displays the number
of days in which a class starts:

Control Source ="(Class starts in " & DateDiff("d",Now(),
[ClassDate]) & " days.)"

For example: (Class starts in 10 days.)

However, if there are more than 30 days things can become
a little confusing to interpret. How can I get it to
state that the class starts in say... 3 months and 21 days?

Thanks for any help!!!

 

[Douglas J. Steele]

Take a look at "A More Complete DateDiff Function"
http://members.rogers.com/douglas.j.steele/Diff2Dates.html