Quarter Generation Problem

[its_anandrjs]

Hi All,

I have problem when i generate Quarter at load wit this syntax:-'Q'&CEIL(MONTH(DATE([Evaluation Date]))/3) as Quarter. it creates three quarters like

Q,Q1,Q2,Q3,Q4 but here Q is unnecesary please tell me how to remove it from Quarter list..

Anand

Regrds

[danielrozental]

you probably have null values in Evaluation Date field.

Try avoiding them like this if(not isnull([Evaluation Date]),'Q'&CEIL(MONTH(DATE([Evaluation Date]))/3)) as Quarter

[#3]

Hi

Maybe the 'Q' value is being concatenated with a null date field.

Try:

IF(ISNULL([Evaluation Date]) = 0, 'Q' & CEIL(MONTH(DATE([Evaluation Date]))/3) ) as Quarter