Having brainfart on date algorithm problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian Simmons - 19 Jul 2007 17:55 GMT

Hi all,

I'm just having one of those days where seemingly easy problems are giving
me a devil of a time.

Here's the scenario:
Company's fiscal year runs from 10/1/YY -> 9/30/(YY+1), i.e. 10/1/2006 ->
9/30/2007

Users are required to enter a FromDate and ToDate for services needed.
The dilemna: The FromDate and ToDate cannot span a fiscal year.

Good dates (arbitrarily picked to give some examples):
10/1/06 -> 11/1/06
10/1/06 -> 2/1/07
10/1/06 -> 9/30/07
3/1/07 -> 9/30/07

Bad dates:
10/1/06 -> 10/1/07
9/30/06 -> 11/1/07
9/1/07 -> 10/5/07

Anyone game for helping me out?

Thanks,
Brian

Reply to this Message

Nicholas Paldino [.NET/C# MVP] - 19 Jul 2007 18:14 GMT

Brian,

First, figure out the minimum of the two dates. Then, calculate the
start of the next fiscal year based on that minimum date. Basically, it is
10/1/xxxx where xxxx is the year of the minimum date. You will have to add
a year if the date is greater than or equal to 10/1/xxxx.

Then, take the other date. If it is greater than or equal to the
calculated date, then it is invalid.

Signature

- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

> Hi all,
>
[quoted text clipped - 23 lines]
> Thanks,
> Brian

Reply to this Message

Brian Simmons - 19 Jul 2007 18:23 GMT

Perfect. This makes a whole lot more sense than the garbage that was
floating around in my head today.

Thanks for your assistance!

> Brian,
>
[quoted text clipped - 33 lines]
>> Thanks,
>> Brian

Reply to this Message

ModelBuilder - 19 Jul 2007 18:30 GMT

static int FiscalYear(DateTime d)
{
int y = d.Year;
if (d.Month > 9) ++y;

return y;
}

static voic main()
{
if (FiscalYear(dtFromDate) == FiscalYear(dtToDate)) //
something good!
}

> Hi all,
>
[quoted text clipped - 23 lines]
> Thanks,
> Brian

Reply to this Message

Having brainfart on date algorithm problem

Free Magazines