Fiscal Year

I have a report that currently gives totals depending on the MOYR you
enter (0405) and it works back to 0005, then it starts with 0405 and
subtracts 1 from yr (0404) and works back to 00 month. They want to
give an option to use fiscal year instead June-May. I am having a time
coming up with logic if you enter 0405 it needs to go back June I
guess. Any help would be appreciated.

Yes. and the same for 01 Jun 2004- 31 July 2004

No, Sorry again, I guess I explained that wrong this is a standard
report, we have 180 companies that use this program the fiscal year
will be determined by a 2 digit code (beginning month) read from the
control-file. So It is parameter driven depending on parameter(98) = 06
or 02 or 12 or whatever.

No, Sorry again, I guess I explained that wrong this is a standard
report, we have 180 companies that use this program the fiscal year
will be determined by a 2 digit code (beginning month) read from the
control-file. So It is parameter driven depending on parameter(98) = 06
or 02 or 12 or whatever.

In article <1114173709.237919.122700@z14g2000cwz.googlegroups.com>,
Jeff <jmoore207@hotmail.com> wrote:
>Yes. and the same for 01 Jun 2004- 31 July 2004

I see... so it would appear that you need something like

If Fiscal-Year-Option
Move 06 To From-MM
Move 01 To From-DD
If To-MM < 06
Compute From-YY = (To-YY - 1)
Else
Move To-YY To From-YY
End-If
End-If

... or am I missing something here?

DD

In article <1114172830.129788.228170@l41g2000cwc.googlegroups.com>,
Jeff <jmoore207@hotmail.com> wrote:
>I have a report that currently gives totals depending on the MOYR you
>enter (0405) and it works back to 0005, then it starts with 0405 and
>subtracts 1 from yr (0404) and works back to 00 month. They want to
>give an option to use fiscal year instead June-May. I am having a time
>coming up with logic if you enter 0405 it needs to go back June I
>guess. Any help would be appreciated.

I am uncertain what it is that you need.  What you have at present appears
to be a routine which, given a month and a year, produces a report based
on the data from the calendar year preceding.

Your fiscal year runs from June - May.  Are you saying that if you run the
report using the fiscal year on 01 Aug 2005 you wish to see data only for
01 Jun 2005 - 31 Jul 2005?

DD

Sorry just got more info. The fiscal year can be any period, different
Companies use different. My example happened to be June-May, but it can
be March - Feb or any other. It's nice to get all the specs up front
huh?

In article <1114182239.613306.4270@l41g2000cwc.googlegroups.com>,
Jeff <jmoore207@hotmail.com> wrote:
>No, Sorry again, I guess I explained that wrong this is a standard
>report, we have 180 companies that use this program the fiscal year
>will be determined by a 2 digit code (beginning month) read from the
>control-file. So It is parameter driven depending on parameter(98) = 06
>or 02 or 12 or whatever.
>

I see... where does the solution proposed fall short of what you need?

DD

In article <1114172830.129788.228170@l41g2000cwc.googlegroups.com>,
Jeff <jmoore207@hotmail.com> wrote:
>I have a report that currently gives totals depending on the MOYR you
>enter (0405) and it works back to 0005, then it starts with 0405 and
>subtracts 1 from yr (0404) and works back to 00 month. They want to
>give an option to use fiscal year instead June-May. I am having a time
>coming up with logic if you enter 0405 it needs to go back June I
>guess. Any help would be appreciated.

I am uncertain what it is that you need.  What you have at present appears
to be a routine which, given a month and a year, produces a report based
on the data from the calendar year preceding.

Your fiscal year runs from June - May.  Are you saying that if you run the
report using the fiscal year on 01 Aug 2005 you wish to see data only for
01 Jun 2005 - 31 Jul 2005?

DD

In article <1114175939.618257.232970@g14g2000cwa.googlegroups.com>,
Jeff <jmoore207@hotmail.com> wrote:
>I think something like that.

I see... where does the solution proposed fall short of what you need?

DD