QtrName without Year suffix

[anushree1]

HI,

I would like to get the QuarterNames like janv.-mars;avr.-juin;juil.-sept.;oct.-;déc..

But when Quartername function is used , it gives quartername with year suffix like janv.-mars 2011

I am able to get the desired result using  SubField(QuarterName([Start Date]),' ',1).

But, Is there any other better alternative to get the same

[Vegar]

This method is as good as any. If it works then keep it like that.

If not then you could use more elaborate on a solution based this logic that I normally use to define quarters.

  'Q' & Ceil(Month(DateField)/3) as Quarter,

[Rohan]

Hello,

Try something like this in your Script.

Month(QuarterStart("date"))&'-'&Month(QuarterEnd("date")) as Quarter_name.

Let me know if it works.