Date Ranges for Billing
I have a table who's records represent projects ongoing at my workplace. Within that table I have a start date field and a durration field. Through a calculation I am able to find the end date. What I would ultimately like to do is to set up a report that will put together a listing of all the projects happening that week. So far I have been able to search based on the start or end date but the dates in between the start and end aren't associated with the record.
An example would be that if I had a project starting today 5/13/2013 and ending in three months on 8/13/2013 I can sucessfully search for it when entering 5/2013 or 8/2013 because the start and end values are within the month. However when I search 7/2013 it comes up with no result.
Like I said above I would like to search by week. I understand the best way to do that is by using "..." between any two dates. Still if I can't locate everything in the month of July by typing 7/2013 I won't be able to do that.
Am I formatting things wrong? What is the best way to show durration from one date to another? I am sure this is a simple process but I am a bit of a beginer.
Any help would be great. Thanks!