Quarterly Data 1

[MaumeeScott]

I need to pull data from the current quarter and the previous quarter based on the Current Date. If the current date were in February I would want the 1st quarter of the current year and the 4th quarter of the previous year.

Thanks!

 

[synapsevampire]

Something like the following in the record selection formula should work:

if currentdate in Calendar1stQtr then
{Orders.Order Date} >= dateadd("m",-3,minimum(Calendar1stQtr))
and
{Orders.Order Date} <= maximum(Calendar1stQtr)

else
if currentdate in Calendar2ndQtr then
{Orders.Order Date} >= dateadd("m",-3,minimum(Calendar2ndQtr))
and
{Orders.Order Date} <= maximum(Calendar2ndQtr)

else
if currentdate in Calendar3rdQtr then
{Orders.Order Date} >= dateadd("m",-3,minimum(Calendar3rdQtr))
and
{Orders.Order Date} <= maximum(Calendar3rdQtr)

else
if currentdate in Calendar4thQtr then
{Orders.Order Date} >= dateadd("m",-3,minimum(Calendar4thQtr))
and
{Orders.Order Date} <= maximum(Calendar4thQtr)

-k