Quote:
Originally posted by M Owen
Gregg,
Problem is trying to use the Floor function within a query ... That requires SQL functions to which Floor is not one of them.
|
Yes, that is the point, I need it inside the query.
The solution:
WHERE (MyTableName.TradeDate>=#Date Literal Here# AND
MyTableName.TradeDate<#Date Literal Here# + 1)
solves my problems.
The point is that the Microsoft Jet 4.0 (the provider I am using) help manual says that it supports scalar functions including floor(). But as I could see it does not support.
There migth be a way to pass-through the query direct to ODBC provider where floor function might work. But it is too technical for me so I will keep the simpler solution above.
I would like to thank you all for your replies.
If someone else has a better idea I would appreciate if he can share with us.
Rgds,
PC2