Determing a quarter in a financial year

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RD - 31 Oct 2004 16:39 GMT

Say Company's financial year starts October First and say we are now March
17th. How do you determine which quarter of the Financial year - not the
actual year - March 17th is in.

Thanks for any help,

Bob

Reply to this Message

Cor Ligthert - 31 Oct 2004 17:12 GMT

RD,

You mean something as this?
\\\
Dim theDate As DateTime = New DateTime(2005, 3, 17)
Dim quarter As Integer = (theDate.Month + 2) \ 3
If quarter = 4 Then
quarter = 1
Else
quarter += 1
End If
///

I hope this is something you wanted/

Cor

"RD" <nospam@nospam.net>
.

> Say Company's financial year starts October First and say we are now March
> 17th. How do you determine which quarter of the Financial year - not the
[quoted text clipped - 3 lines]
>
> Bob

Reply to this Message

RD - 31 Oct 2004 19:24 GMT

Thanks Cor but I must be missing something.
Your bit of code does not seem to take into consideration that the first
quarter of the financial year starts on October First not January First , if
it does I do not see how? If it does would you mind explaining it to me?

Thanks

> RD,
>
[quoted text clipped - 22 lines]
> >
> > Bob

Reply to this Message

Cor Ligthert - 31 Oct 2004 19:54 GMT

RD,

Did you try it?
The 1st of October gives at me quarter = 1
The 1st of January gives at me quarter = 2
The 1st of April gives at me quarter = 3
The 1st of July gives at me quarter = 4

Where did I understood you wrong?

Cor

"RD" <nospam@nospam.net>
..

> Thanks Cor but I must be missing something.
> Your bit of code does not seem to take into consideration that the first
[quoted text clipped - 31 lines]
>> >
>> > Bob

Reply to this Message

Determing a quarter in a financial year

Free Magazines