How do I redefine 1st Quarter in Access

  • Thread starter Thread starter Guest
  • Start date Start date
Here is a formula that will do what you want:
iif(datepart("q",dtmSomeDate)-1 = 0, 4, datepart("q",dtmSomeDate)-1)
 
I wish to make the fist Quarter of the year = April 1 to June 30
Click to expand...


You can generate a calculated field for this definition by
timeshifting the date:

DatePart("q", DateAdd("m", -3, [datefield]))

John W. Vinson[MVP]
 
This might be the right formula, but where do I enter it?
Step by step please. Thank you

John Vinson said:
I wish to make the fist Quarter of the year = April 1 to June 30
Click to expand...


You can generate a calculated field for this definition by
timeshifting the date:

DatePart("q", DateAdd("m", -3, [datefield]))

John W. Vinson[MVP]
Click to expand...
 
This might be the right formula, but where do I enter it?
Click to expand...

I have no idea, because I do not know what YOU want to do with the
value, nor anything about the structure of your table, your form, your
report, or whatever that might be.

John W. Vinson[MVP]
 

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

quarterly reports in Access 1
Current year Quarterly totals 2
Pick Year and Pick Quarter 1
Return the current Yearly Quarter based on date 2
Pivot Table - Quarterly report 1
Calculate a quarter 16
Pick Year and Pick Quarter 1
Combine a text and number field to create a date 2

Back
Top