Confusing date difference problem

S

Susan

I am trying to find a formula that counts the number of
days a client has received services within a given month.
It should be easy enough, but what complicates it is that
some may start receiving services the prior month, and
some may start in the middle of the month in question.
For example, one may have received services from May 14th
through June 23rd, and another from June 2nd through June
19th, and still another from June 2nd through July 8th.

How can I structure one formula that takes all this into
account? I can find the difference between the two dates,
but not within a particular month. I'm using two dates:
Start date and end date.

I'm still a novice at Access, so the simpler the easier on
my little mind! Thanks in advance for any assistance.
 
G

Guest

I don't write in code but here is what I put in for the
field in a query with Turnaround being the new field name.

Turnaround:=datediff("d",[End Date],[Start Date])

Good Luck!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top