Determing a quarter in a financial year

[RD]

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

[Cor Ligthert]

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" <no****@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
actual year - March 17th is in.

Thanks for any help,

Bob

[RD]

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
"Cor Ligthert" <no************@planet.nl> wrote in message
news:em**************@TK2MSFTNGP12.phx.gbl...

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" <no****@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
actual year - March 17th is in.

Thanks for any help,

Bob

[Cor Ligthert]

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" <no****@nospam.net>
...

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
"Cor Ligthert" <no************@planet.nl> wrote in message
news:em**************@TK2MSFTNGP12.phx.gbl...

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" <no****@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
> actual year - March 17th is in.
>
> Thanks for any help,
>
> Bob
>
>