1701444 - How to display quarter number with the year

SAP Knowledge Base Article - Public

1701444 - How to display quarter number with the year

Symptom

 How to display quarter number with the year

Environment

Crystal report 2008

Crystal report 2011

Resolution

  1. Create a sample report which consists of any date field
  2. 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