darn dates again

[onressy]

Hi i always seem to be stuck doing something i'm not good at, yet.
Any suggestions on determining which days (if any) the Discount rate range is in the RateStartDate to RateEndDate range. Dates are in format 2006-09-01

strDiscountStart
strDiscountEnd

RateStartDate
RateEndDate

 

[TheCandyman]

Need more info.

I have read over your question a few times, and i'm still unclear what you are asking. Is the RateStartDate a day or date? Are you given info the discount lasts 4 days? or 10-1-2006 through 10-6-2006? Are you applying this to a output of some sort?

 

[Sheco]

I think maybe the question is how to determine if one date range overlaps another separate date range.

 

[johnwm]

If so, just convert your strings to dates and loop through using >= start AND <= finish

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[TheCandyman]

If that's all you need, then your answer is here:

http://www.tutorialized.com/tutorial/Compare-dates/1530

 

[onressy]

RateStartDate is a date, like 2006-08-27

giving a discount to the duration during the DiscountStart to DiscountEnd

If the range of RateStartDate to RateEndDate is in the DicountDate range then presedence is given to the discoutDate cost for the part that the discount date duration overlaps the RateStartDate to RateEndDate duration

 

[onressy]

thanks all!