Which Quarter of the Year is today in?

[sgfromny]

When a record is created, I give it a date stamp. I also need to calculate which quarter 1st 2nd 3rd 4th. Any Ideas?

 

[psemianonymous]

The built-in Format function has what you need:

Format(Date(), "q")

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[luceze]

You can use this formula:
=IIF(MONTH([YOURFIELD])<4,1,IIF(MONTH([YOURFIELD])<7,2,IIF(MONTH([YOURFIELD])<10,3,IIF(MONTH([YOURFIELD])<13,4))))

where [YourField] is the name of your DateStamp field.

HTH,
Eric

 

[sgfromny]

Thanks, The built in function worked perfectly!

 

[axilla2]

careful though, calendar quarter or fiscal quarter?

especially now, with financial reporting being under scrutiny, c/o Mr Sarbanes and Oxley.

in my case i had to load the company's fiscal calendar into a separate table and lookup the quarter.

 

[wandak]

DatePart(interval,date) For quarters, the interval will equal &quot;q&quot;. This is based on the calendar year. It will return a number: 1, 2, 3 or 4. Intervals also include weeks, &quot;ww&quot;, which returns a number from 1 to 52.

Example: YourDate is 1/23/03. DatePart(&quot;q&quot;,YourDate) will return 1 for 1st quarter.

If your using a fiscal year, calculate what week YourDate is in, then assign it to the fiscal quarter.