datedif function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a parameter query [enter days] to retrieve records whose dates are
more than [enter days] beyond today. I am using Expr1:
DateDiff("d",[invoiceDate],Date())in the field box and then using[enter days]
in the criteria line. This returns dates more than 30 days from today if I
enter 30 and also returns any date which is a single digit from today (1-9).
Anybody know why its doing this?
 
I'm not getting that, please copy and paste the SQL view of your query into
a message.
 

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

query usung datedif function 1
Excel DateDif - why does 2007 seem different? 3
Help with Query syntax 2
Help with 3 scenerio query 1
Expression too complex ... ? 2
Excel Formatting with dates 3
Date and Parameter question. 4
Aging Invoice Report 8

Back
Top