P polgara Registered User. Local time Today, 15:58 Joined Feb 22, 2001 Messages 11 Apr 12, 2002 #1 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?
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?
David R I know a few things... Local time Today, 09:58 Joined Oct 23, 2001 Messages 2,633 Apr 12, 2002 #2 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
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