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
 
Back
Top