date - # of days calcuation
- From: "Donna" <Donna@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 6 Jun 2005 15:35:32 -0700
I have a table that has a field for a begin date & a field for an end date.
A person may check into the shelter on 6/15 and leave on 7/15, for example.
The problem is I need to figure out how many days we supplied overnight
housing for people for the month of JUNE only. Can I do that with just these
2 fields, or should I redesign the database to put some other field in there?
.
- Follow-Ups:
- Re: date - # of days calcuation
- From: fredg
- Re: date - # of days calcuation
- From: Jeff Boyce
- Re: date - # of days calcuation
- Prev by Date: Re: Sorting Crosstab after Format of Date
- Next by Date: Re: Creating a select query to find the MAX volume between certain dates
- Previous by thread: Creating a select query to find the MAX volume between certain dates
- Next by thread: Re: date - # of days calcuation
- Index(es):
Relevant Pages
|