Information générale
Catégorie:
Codage, syntaxe et commandes
>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement