DatePart- function "Quarter"

[imfarhan]

Hi
If I'm right we are in Quarter =1 ,so why my following query brings the result quarter=2 ?

Select
DatePart("q",Now()) AS Financial_Quarter,
"01/04/" & IIf(DatePart("q",Now())=1,Year(Now())-1,Year(Now())) As Fi
FROM Table_Name

Ans= 2 ?

Thanks in advance

Many thanks
Farhan

 

[Joe4]

If I'm right we are in Quarter =1 ,so why my following query brings the result quarter=2 ?

No, we are actually in the second quarter now. The first quarter ended March 31 and the second quarter started April 1. Today is April 8, putting us in the second quarter.

 

[imfarhan]

I think bit confusion, the starting quarter of the Financial/fiscal year is
Apr to Jun = 1st Quarter
Jul to Sep = 2nd Quarter
Oct to Dec = 3rd Quarter
Jan to March = 4th Quarter

As per above rule the current quarter should be " 1 " using today's date i.e. 08/Apr/2010

Sorry , bit mixing the financial jargon wording

Many thanks
Farhan

 

[Joe4]

Ah, you didn't mention that you were dealing with a non-standard quarter calendar.

Something like this calculation should work:

IIf(DatePart("q",Now())=4,1,DatePart("q",Now())+1)

 

[imfarhan]

Many thanks Joe

You sorted my problem
Kind regards
Farhan