Displaying Quarterley values from Date Ranges or Months

[actionman007]

Hi,

I currently am working on a database that has a specific date for when work has to be done, the client has requested that this be displayed as Quarters of the financial year.

So what I need to do is to take 18/04/07 and assign it to a value of Q1 etc.

What is the best way of doing this?

--

I'd like to be able to set the date, and then a box to the left of the date, automatically populate with Q1, Q2, Q3, Q4...

Your help is always appreciated!

Cheers,

Dan :)

[mr_vodka]

Wouldnt 18/04/07 be Q2?

Create a calc field with text result.

"Q" & GetAsText (Div ( Month ( yourdate ) - 1; 3 ) + 1 )

or

Choose ( Div ( Month ( yourdate ) - 1; 3 ); "Q1"; "Q2"; "Q3"; "Q4" )

Edited April 18, 2007 by Guest

[actionman007]

Hi,

Our Financial year starts in April so this is the following:

Q1 - April, May, June

Q2 - July, August, September

Q3 - October, November, December

Q4 - January, February and March

This calc script seems to be a month out on the quarters, how do I adjust it?

Cheers,

Dumbo Dan :)

[mr_vodka]

Try

Choose ( Div ( Month ( yourdate ) - 1; 3 ); "Q4"; "Q1"; "Q2"; "Q3" ) )

BTW, this would have been good to know earlier.

Our Financial year starts in April so this is the following:

Q1 - April, May, June

Q2 - July, August, September

Q3 - October, November, December

Q4 - January, February and March