>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?
UserStartDT, as used in your expression, *must* be a Date type - which is not what your variable name implies. Look at the actual value and type of UserStartDT in the debugger or at the command prompt.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up