DateDiff() excluding start and end date

[jastek]

Can you make the DateDiff function exclude the start and end dates?

example:

start date = 5/1/04
end date = 5/3/04

date difference is = 1

 

[Rich]

DateDiff(etc )-2

 

[jastek]

That works fine, unless I am comparing two dates that are together. Then I will get a negative number.

start date = 5/1/04
end date - 5/2/04

Date Difference = -2

 

[jastek]

Never mind. I put an if statement at the end to make values < 0, = 0

Problem solved.

If anyone knows of a way to make DateDiff do this automatically, I would like to know how.