DATEDIFF function problem

[WB]

The expected results of a query using the datediff function as part of the
criteria is causing a problem

This works properly: DateDiff("d",t3.TransactionDate, now()) > 150

This doesn't work properly: DateDiff("d",t3.TransactionDate, now()) >
[Enter Days]


Does anyone have information on why there is a difference?

Thanks in advance
WB

 

[Wayne Morgan]

I suspect that Access/Jet is guessing wrong about the data type of [Enter
Days]. Try specifying by adding the following line to the start of the SQL
view (i.e. prior to SELECT ....)

PARAMETERS [Enter Days] Short;
or
PARAMETERS [Enter Days] Long;

The options are for an Integer or Long Integer data type. You can also do
this in Design view by going to Query|Parameters... and typing in [Enter
Days] under the Parameter column and picking a data type.

 

[WB]

Thanks, worked perfect.

I suspect that Access/Jet is guessing wrong about the data type of [Enter
Days]. Try specifying by adding the following line to the start of the SQL
view (i.e. prior to SELECT ....)

PARAMETERS [Enter Days] Short;
or
PARAMETERS [Enter Days] Long;

The options are for an Integer or Long Integer data type. You can also do
this in Design view by going to Query|Parameters... and typing in [Enter
Days] under the Parameter column and picking a data type.

--
Wayne Morgan
MS Access MVP

The expected results of a query using the datediff function as part of the
criteria is causing a problem

This works properly: DateDiff("d",t3.TransactionDate, now()) > 150

This doesn't work properly: DateDiff("d",t3.TransactionDate, now()) >
[Enter Days]


Does anyone have information on why there is a difference?

Thanks in advance
WB