date calculation on a report

  • Thread starter Thread starter Mark
  • Start date Start date
M

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!!!
 
Back
Top