numbers of date between many dates: more explanation

  • Thread starter Thread starter Solange:\)
  • Start date Start date
S

Solange:\)

more explanation:

We receive the account of students Loan and we have to
verify all transaction payment. So my dates are the dates
when the students did their payment.
We have to calculate the interest rate between each
transaction so I need to know the numbers of dates
between each transaction ( we can have 50, 250.
transactions....)

I need numbers of dates more than two dates. Again this
are some transactions from the bank. Each time the student
did a payment. So I have many dates and it's not
necessary once a month. It could be once in three months.
It could be twice a month.10 time a year...

I know I can use Datediff() for two dates but I need for
many dates....

Thank's again for you help..
Solange:)

*********************************
-----Original Message-----
I need to calculate the numbers of days between many
dates.
Ex.
This is the dates of some transactions:

1-02-07-2003
2-07-07-2003
3-20-07-2003
4-28-07-2003
5-05-08-2003

I need to know the days between :

1-07-07-2003 and 02-07-2003
2-20-07-2003 and 02-07-2003
3-28-07-2003 and 20-07-2003
4-05-08-2003 and 28-07-2003

Thank you verry much for your help !!
Click to expand...

I explain:

How did you pick these particular dates? Do you want every
possible
pair of dates in the table, or what?

We receive the account ot student Loan and we have to
verify all transaction payment. So my dates are the dates
when the students did their payment.
We have to calculate the interest rate between each
transaction so I need to know the numbers of dates
between each transaction ( we can have 50, 250.
transactions....)
Do you follow me ?

************
I need for more than two dates. Again this is some
transactions from the bank. Each time the student did a
payment. So I have many dates and it's not necessary once
a month. It could be once in three months.It could be
twice a month.

Thank's again for you help..
Solange:)
 
I need numbers of dates more than two dates. Again this
are some transactions from the bank. Each time the student
did a payment. So I have many dates and it's not
necessary once a month. It could be once in three months.
It could be twice a month.10 time a year...
Click to expand...

Please describe the structure of you table (or tables). I think I have
a very fuzzy idea but I hesitate to make a suggestion (like I did
yesterday) on insufficient information!
 
I have been trying to reach John since yesterday but I
can't.This is his address.
<jvinson@STOP_SPAM.WysardOfInfo.com>
Is that possible to tell him ??
 
Back
Top