Date Range comparisons

[Brad_Wells_(Guest)]

Can you help me define a formula for comparing the overlap between 2__date ranges?____For example, if I have 2 columns of information, each containing date__ranges - can we compare them and report in another column the number of__days of overlap?__

[kfleming]

Do you have two single date field and then at the bottom of the report want to compute the overlap between the highest and lowest dates in each column or do you have two character fields, each containing a start/end date and want to compute overlap on a per record basis?____Kathleen__R&R Support

[Brad_Wells_(Guest)]

Kathy, ____I am working with text fields of the two date ranges. I think I have this figured out. I am parsing the date ranges into sperate fields and if date range 2 begin date is before date range 1 end date I am using daysbtwn + 1 to calculate the overlapping number of days.____I am going to test this out over the weekend.______Take care and have a great week-end.____Thanks,______Brad