Symptom
How to display quarter number with the year
Environment
Crystal report 2008
Crystal report 2011
Resolution
- Create a sample report which consists of any date field
-
Write a formula as
Totext ( DatePart ( 'q' , {Orders.Order Date}) , '0')
& 'Q'
& Totext (Year ({Orders.Order Date}), '0000')
If the date is 13/2/2008 then it will display as 1Q2008
Keywords
Quarter number of the year, year of the quarter, quarter number in crystal 2008, quarter number in crystal 2011, Quarter Number, Quarter , KBA , BI-RA-CR-DSL , Crystal Reports on C++ Data Semantic Layer (ClassicUniverse) , How To
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011