calculation of month inteval

E

Elwin

DateDiff("m",#1/31/2004#,#2/29/2004#)
DateDiff("m",#1/31/2004#,#2/1/2004#)

both of these return 1

the 1st parameter can be;
y = year
m = month
d = day
h = hour
n = minute
s = second
-----Original Message-----
looking to calculate interval between two dates down by
month at the fraction of a month interval.
 

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

Top