Problems with date filter in a query

Question

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

Mike Schmitt · Answer

My first instinct is to suggest you keep hunting for any issues with your particular configuration, because I've done this many times and it's always worked without much trouble.

Mike Schmitt · Answer

I would suggest you try it without "toDate()" -- either try just "now()", or try "today()" to return a datetime value with just the date (i believe either of these should work for your filter though). 
 If that still doesn't seem to work right, you might want to check that the CDT used by the Data Store Entity you're querying from has the "fechaVencimiento" column declared as the correct data type (i.e. that it's date, and not text or something else incorrect).

vimalkumars · Answer

Hi Sandrap845, 
 toDate(now()) - This value actually contains date with timestamp. You can check the timestamp by using the below expression: 
 datetext(todate(now()), "z") 
 
 Can you try the below expression and see what is the date returned: 
 date(year(now()), month(now()), day(now())) 
 
 Then you can change your query filter as below and see how it works a!queryFilter( field: "fechaVencimiento", operator:">", value: date(year(now()), month(now()), day(now())) ) 
 
 Hope this helps

Problems with date filter in a query

Top Replies