Formula in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to find an formula that will translate a date into a calendar
quarter. For example, what , if any, formula would translate the following:

Date Month Calendar Quarter
1/15/05 1 1
5/5/05 5 2

I know what function to use for the Month translation, but not sure if a
formula can give me the quarter translation.
 
Hello there,

Try this:

Quarter: Format([Start Date],"q")

Hope this helps

Judith
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to calculate average for current quarter? 1
grouping quarters 3
Is there a way to make positive numbers appear as +XX ? 4
Calculate Start and End Date of a Quarter 8
Please help me fix this flawed query formula 7
Crosstab - Calculation 3
Formula Help 1
Need Help with Formula Expansion 5

Back
Top