Add year to group in a report

polgara

Registered User.
Local time
Today, 11:06
Joined
Feb 22, 2001
Messages
11
Wondered if there was a solution to this problem:

=Format$([Profilecreated],"mmmm yyyy",0,0)

I want to show the expiry of the profile which would be 12 months from the date created. Do I just use DateAdd?
 
I think you'd have to DateAdd before you Format, or use string manipulation, but yes, that should do what you're asking.

David R
 

Users who are viewing this thread

Back
Top Bottom