To extract current and previous quarters data.

[#1]

Hi All,

I want to write a conditon in such a way that i need to extract data for current and previous quarter.

how do i write condition in script to get that data.

Plsss help......

thanks in advance

[#2]

Hi,

You can define a flag in the script like:

(month(today(0))&Ceil/3) as CurrentQtr

The same approach can be done for Previous Quarter.

So every time the Month changes in the system calendar it will affect on Quarter too

Regards,

Sunil

[#3]

u can use Inquarter() or InQuartertodate() functions to get current and Previous quarter

[#4]

Hi,

InQuarter etc will only return a true/false statement - if you are looking for 1,2,3,4 then sunils will work but with a slight tweak

ceil(month(today(0))/3)

The ceil in that location will be seen as a field name.   Ceiling the whole result will give you the current quarter