day/month stamp

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

Mark

Hello all,

I used the following in the control source of a text box
to return the number of days until the class sarts...
example: (Class starts in 7 days).

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

I wanted to find out if I could change this a bit to
display how many months and days. For example: (Class
starts in 2 month(s) and 15 days). Or if the class starts
within one month to have displayed: (Class starts in 20
days).

I guess a "Case" statement would do the trick well, but
can I write the case statement in the control source line
of the properties box? How would I go about acomplishing
this task? Not sure how the code would be written or
where to place it.

Thanks for any assistance!
 
Back
Top