urgent help needed

[#1]

Plez I need urgent help to find the quaterly sales of the country. I did the following things,

  Year(OrderDate)as OrderYear,

     year(OrderDate)& month(OrderDate)as MonthYear,

     Year(OrderDate) & Ceil(Month(OrderDate)/3) as YearQtr,

     RequiredDate,

any link or website with detail of edit script will be more welcome

thank you

[jpapador · Accepted solution]

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

Dual('Q' & Ceil(Month(Date)/3) & '-' & Year(Date), Year(Date) & Ceil(Month(Date)/3)) as QtrYear,

Date(MonthStart(Date), 'MMMYYYY') as MonthYear

Try that.  Replace "Date" with "OrderDate"

[#3]

Thanks you so much jpapador.Really appreciated.