Quarter Function

[ch_riadh]

i wrote the quarter function : 'Q' & Ceil (Month(Date)/3) AS Quarter,

But It  SHowed me :

  

I Don't want to see the Q,
i need Only Q1, Q2, Q3 and Q4.

Thank Guys.

[MK_QSL]

Instead of using FieldName Quarter in List box use expression and use below

=if(Len(Quarter)>1, Quarter)

[its_anandrjs · Accepted solution]

It seems correct can you share app or you can do some change in the load script

Load

If( Len( 'Q' & Ceil (Month(Month)/3) >1, 'Q' & Ceil (Month(Month)/3) ) as Quarter

From Source;

Regards

Anand

[ch_riadh]

where i have to write this expression ?

[sujeetsingh]

In the Calender where you are using Quarter function and derieving the Quarter field, and using  in the ListBox image, just use the expression

If( Len( 'Q' & Ceil (Month(Month)/3) >1, 'Q' & Ceil (Month(Month)/3) ) as Quarter

[ch_riadh]

Thanks