>I have a data file that has a datetime field and I need to allow a user to get records between 2 dates. In the view builder I select ttod(dtfield) >= userstartdt (where userstartdt) is a date variable.
>
>The query blows up saying operator operand type mismatch. If I substitute date() in for userstartdt the query runs fine.
>
>Any Ideas?
>
>TIA
>Chris
Can you post a SQL statament that the view builder creates?
You can get to it by clicking on SQL batton on View designer toolbar.