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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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