Using a 360 day year

M

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.
 
J

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.
Click to expand...

Hmmm...

Try:

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


John W. Vinson[MVP]
 
Top