How to compare today's date with the date mentioned in the column

I need to compare the present date with the date in the column.
Suppose date in the column is 05/12/2016 00:00:00 and the today;s date be 05/12/2016
When I compare this, it is considering time also. I need to compare only date by ignoring time.

How to do this???


You can search data by query like: “date > %start_date% AND date < %end_date%”.




How to compare whether the date is equal to today’s date or not.

I tried using = operation, but it is comparing time also,
If I compare 05/13/2016 00:00:00 with 05/13/2016, it is not equal. But I need it to be true

The date is serialized as a number on the server, thus you can’t directly separate in into date and time.