Using a 360 day year

[Matty B]

I have been trying to find a way of calculating the number of days
between any two dates on the basis that each year has 360 days (i.e
each month is made up of 30 days)

I know that this can be done in Excel using the Days360 formula but how
can this be done in Access? I am using Access 97.

 

[John Vinson]

I have been trying to find a way of calculating the number of days
between any two dates on the basis that each year has 360 days (i.e
each month is made up of 30 days)

I know that this can be done in Excel using the Days360 formula but how
can this be done in Access? I am using Access 97.

Hmmm...

Try:

Days360: 30*DateDiff("m", [startdate], [enddate]) + DatePart("d",
[EndDate]) - DatePart("d", [StartDate])


John W. Vinson[MVP]