troubleshooting Question

Totext and year

Avatar of Mark Wilson
Mark Wilson asked on
Crystal Reports
7 Comments1 Solution740 ViewsLast Modified:
I am using the following formuas for headings in my report

iif(month(today)=1,"Jan - " & totext((year(currentdate)-1),0,""),"Jan - " & totext((year(currentdate)),0,""))

i.e. the example is the jan heading, if the month of the current date is 1 then heading should be Jan + last year i.e. Jan-2011 else month plus this year i.e. Jan-2012

Is there a better way of doing this and is there a way of getting the year to 2 digts so it will diplay as Jan-11 or Jan-12?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros