DSXchange

Posted: **Tue Aug 30, 2011 9:52 am**

Hi,
I have a requirement where I need to convert the date into quarters.Please can anyone tell me how to achieve this.
example
date Quarter
20/03/2009 Q109
20/06/2009 Q209
20/09/2010 Q310
20/11/2011 Q411

Posted: **Tue Aug 30, 2011 1:57 pm**

You can get ur results from following stage variables.

sv1: MonthFromDate(input_date)/3
sv2: Ceil(sv1)
sv3: 'Q' : sv2 : YearFromDate(input_date) [3,2]

DSXchange

how to change date to quarter

how to change date to quarter

Re: how to change date to quarter