Start Date to End Date Overlap Last Month 1

[mychal]

I have a table with a Start Date field and an End Date field. I want to see all records in that table where the range between the Start Date and End Date hit some or all of last month.

For example, if this is my data:

Record # Start Date End Date
1 10/3/2004 10/15/2004
2 10/8/2004 11/13/2004
3 9/2/2004 12/3/2004
4 11/5/2004 11/20/2004
5 11/7/2004 12/4/2004
6 12/2/2004 12/5/2004

I would want to return 2, 3, 4, and 5.

How could I do this?

Thanks.

 

[vidru]

I think this'll do it:

(Minimum(LastFullMonth) in {Table.StartDate} to {Table.EndDate}
Or
Maximum(LastFullMonth) in {Table.StartDate} to {Table.EndDate}
Or
({Table.StartDate} in LastFullMonth And {Table.EndDate} in LastFullMonth))

-dave

 

[mychal]

Excellent. Much more concise than my method.

Thanks.