>>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.

I agree thats what it would look like but when I look it up its absolutely a date. I can even add 4 to it and get a date 4 days ahead.


CG