datediff

G

Guest

I am using the datediff("d",[EndDate],[BeginDate]) to calculate the number of
days attended. If I use [EndDate]=1/1/01 and [BeginDate]=1/1/01 I want 1 as
an answer not 0. [EndDate]=1/10/01 and [BeginDate]=1/1/01, I want 10 as an
answer not 9. Any Ideas. Thanks
 

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

Similar Threads

Date Diff Questions 2
Date Parameter Query 5
Syntax problem! 4
Date Diff Function 2
Days Count Sheet Help 5
WorkingDays Function (need hrs, not days) 4
Compare Date 1
Query/Report on dates between begin and end 1

Top