From: rick.rans@canada.com
Don't know if this helps but the first two cross month boundaries and the
third one is in the same month.
"Jeanette" wrote in message
news:45d0c915$1@pnews.thedbcommunity.com...
>
> You're OK, I undersood what you said, I BELIEVE.
>
> Even though I know the ASSUME THEORY I ASSUMED the # would be the actual
> # of days like 12/31/05-1/1/05 would be 365 and not 364.
>
> I guess I am being too wordy. Are there any SPECIFIC rules regarding the
> arithmentic of Dates? I'm looking for some rules about when a date range
> will be INCLUSIVE.
>
> It seems like:
> a) 02/1/06-1/15/06 is INCLUSIVE (17)
> b) 12/31/05-9/15/05 is INCLUSIVE (107)
> BUT
> c) 10/1/06-1/1/06 is NOT INCLUSIVE (9)
>
> I don't understand why a&b are INCLUSIVE and c is NOT...
>
> SORRY - maybe it's in my face and I just don't see it !
>
> Liz McGuire wrote:
>>I don't know how else to explain it. 198 excludes the start date from
>>the calculation. 90 and 107 exclude two start dates from the
>>calculation. If you want to exclude the start date, I reckon you'll
>>have to:
>>
>>a) use the min start and max end - gets you 198
>>
>>OR
>>
>>b) count how many rows there are for the given street, sum the two
>>ranges and add n-1, where n is the number of rows.
>>
>>Or something.
>>
>>Liz
>>
>>
>>Jeanette wrote:
>>> Helpful but...
>>> the idea is to get a daily cost and project it given the BGN & END dates
>>> and then the amounts should roll up to the original StreetCost.
>>>
>>> It's not happening if I use 199 days for the example below.
>>> HOWEVER if the BGN & END dates were not broken up by a RptYear the TNOD
> would
>>> be 198 and that allows an accurate rollup to the StreetCost BUT as
>>> (END-BGN).
>>>
>>> AND using dates 1/15/06 thru 2/1/06 and 9/15/05 thru 12/31/05 for 2
>>> seperate
>>> streets (END-BGN)+1 does not allow an accurate rollup to the StreetCost
> -
>>> it does if (END-BGN)is used...
>>>
>>> WHAT TO DO ????
>>>
>>>
>>>
>>>
>>> "Liz McGuire" wrote:
>>>> Jeanette,
>>>>
>>>> 1 through 10, inclusive, includes a total of 10 numbers.
>>>>
>>>> 10 - 1 = 9
>>>>
>>>> 1 is subtracted, so there's only 9 numbers left.
>>>>
>>>> The first date range (2005) has 108 days, inclusive. The second has
> 91
>>> days
>>>> (inclusive). Together, there are 199 days (inclusive).
>>>>
>>>> However, when you're doing date math, "EndDate - StartDate" **subtracts
>>> the
>>>> start date**. In other words, the StartDate is not being included in
> the
>>>> count of days. If you want to be inclusive, do:
>>>>
>>>> (EndDate-StartDate)+1
>>>>
>>>> ...then you'll get 108 days in 2005, 91 days in 2006 and 199 days
>>>> total.
>>>>
>>>> HTH,
>>>>
>>>> Liz
>>>>
>>>>
>>>> "Jeanette" wrote:
>>>>> I am creating a report that shows construction Cost projections.
>>>>> Given the bgn & end dates Costs are shown via Month and Year.
>>>>> For each street I calc the # of days between bgn & end and sum them
> to
>>> get
>>>>> a grand total # of days (TNOD). The street cost is divided by TNOD for
>>> a
>>>>> daily cost.
>>>>>
>>>>> here's the hitch - in the example below:
>>>>> 2005 # = 107
>>>>> 2006 # = 90 for a TNOD of 197
>>>>> if I were able to get the # of days via MAX(end) - MIN(bgn) I would
> have
>>>>> a TNOD of 198 since the dates are consectuve months.
>>>>>
>>>>> Can you help me code this occurence?
>>>>>
>>>>> Year StreetCODE StreetCost Begin End
>>>>> 2005 06520 $282,208.40 09/15/2005 12/31/2005
>>>>> 2006 06520 $282,208.40 01/01/2006 04/01/2006
>>>>>
>>>>>
>>>
>
--- SoupGate-Win32 v1.05
* Origin: you cannot sedate... all the things you hate (1:229/2)
|
