Question

Custom Search on Date field

0

I am trying to implement a custom search on my grid. I am facing issue with implementing Date comparison in the Xpath. I am doing it like "[DueDate = $TaskSearch/DueDate]". But it doesn't fetch any results even though there are records matching that scenario. As we are doing this in Xpath there are not many date functions to help on this. Is there any easy fix on this?

asked 2017-01-18

Mangesh Unde

1 answers

Ronald Catersels · Accepted Answer · 2017-01-18

Did you also check the timestamp? Because each date also consist of a time part and if they for some reason are different you will find no result. If you are running local you could check your postgres database to check the value.

Regards,

Ronald

[EDIT]

My advise is that you create two date objects, one the start of the day and one the end of the day. See the documentation about creating dates. Then you can use those to do an xpath compare >= or <=.