datedif function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drazlou - 29 Mar 2006 03:33 GMT

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?

Reply to this Message

Wayne Morgan - 29 Mar 2006 03:50 GMT

I'm not getting that, please copy and paste the SQL view of your query into
a message.

Signature

Wayne Morgan
MS Access MVP

>I am using a parameter query [enter days] to retrieve records whose dates
>are
[quoted text clipped - 5 lines]
> (1-9).
> Anybody know why its doing this?

Reply to this Message