Hello,
I have a problem with date filter in a query,
This is the code:
filters: { a!queryFilter( field: "fechaVencimiento", operator:">", value: toDate(now()) ),
fechaVencimiento is date of BBDD.
The problem is that when I execute the query it is returning the last two records, while I should not return anything because those records have the current date but not greater.
Do you know any solution for this?
Regards, and thank you very much
Discussion posts and replies are publicly visible
Thanks, that's useful to know. I suspect someone may have updated the CDT via the editor without updating its data type in the XSD file, though it's hard to know for sure what exactly happened.
hello Karina
I finally deleted the CDT and generating it again worked.
Hi vimalkumars