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