Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Do not give your attention to what others do or fail to do; give it to what you do or fail to do
 
Dhammapada
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

19
June

How Do I Display the next 3 Months in Crystal Reports XI?

I had a client recently ask me "How do I display the abbreviated names  the next 3 months from a specified date time field in Crystal Reports XI?"

Solution:

Use the following formula:
 
Monthname(Month(Tablename.Fieldname), True) & ", " & Monthname(Month(Dateadd('m',1,Tablename.Fieldname)), True) & ", " & Monthname(Month(Dateadd('m',2,Tablename.Fieldname)), True)



If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

7 + 41 =