asked on

select current quarter in SQL query based on company fiscal year

Hello, experts,

How do I select the current quarter based on company fiscal year. I defined the quarters as follow:

CASE
WHEN MONTH(getdate()) BETWEEN 6 AND 8 THEN 'Q1 - '
WHEN MONTH(getdate()) BETWEEN 9 AND 11 THEN 'Q2 - '
WHEN MONTH(getdate()) BETWEEN 12 AND 2 THEN 'Q3 - '
WHEN MONTH(getdate()) BETWEEN 3 AND 5 THEN 'Q4 - '
END as Qtr

I need passing the current Qtr to a query:

Select * from Margin where createdon =current Qtr

Thank you very much in advance.

Jim Horn

Dang dang dang dang dang.

I have an article there on Date Fun, Part One: Build your own SQL calendar table to perform complex date expressions, which walks you through how to handle goofy-riffic calculations involving days by storing them in a table.

The 'Part Two' is how to handle fiscal years, which isn't ready for the world yet.
I take it you're dealing with crop year?

In your case, in what format is the createdon values? Based on that we can kick out some T-SQL, and I'm guessing it'll be a nested CASE block based on what you already have, that handles the year component.

ASKER CERTIFIED SOLUTION

Kyle Abrahams, PMP

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sharon2011

ASKER

ged325,

I just made my sql query work beautifully.

Thank you very much