Jump to content
Sign in to follow this  
actionman007

Displaying Quarterley values from Date Ranges or Months

Recommended Posts

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 :)

Share this post


Link to post
Share on other sites

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 by Guest

Share this post


Link to post
Share on other sites

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 :)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.