How to automatically show current quarter?

[latestgood]

Hello,

I am trying to create user friendly form but I am stuck with date. I want access to automatically show current quarter when user enters the date. For example, if user enters July, I want access to automatically fill out the correct quarter. The problem I have is that our company's quarter starts in June. Any advice will be appreciated.

 

[dnesci]

I'm not sure how you are planning to have the user enter the dates but you could use the Month(datevalue) function. It will return a number from 1-12 of the date value. You could then check if the month is between 6 and 8 for quater 1, 9-11 for quarter 2, etc.

 

[John Big Booty]

Welcome to the forum.

Check out the DatePart() function.

DatePart("q", Date())

will return the quarter number of the current date.

 

[dnesci]

Welcome to the forum.

Check out the DatePart() function.

DatePart("q", Date())

will return the quarter number of the current date.

John this is good, but I avoided it as his quarter begins in June and not July.

 

[John Big Booty]

John this is good, but I avoided it as his quarter begins in June and not July.

Fair enough. I must admit I missed that vital point

 

[John Big Booty]

Perhaps this schema (or at the very least a variation on it) will return the correct quarter required by the OP;

=DatePart("Q",DateAdd("M",-1,[DateValue]))

It should just be a matter of getting the correct offset in the DateAdd() portion of the statement.