hi, what is formula in saved to compare whether two dates are equal.

Try subtracting them and then validating if the result is zero (or sometimes might need to validate if between 1 and -1)

This works: CASE WHEN {date1} = {date2} THEN ‘Yes’ ELSE ‘No’ END used in a Formula text result.

one field has date and time

No if you do a comparison between a date and a Date/Time then you will never get a match. that is where the subraction of the 2 will give you a result of 0.0003455 or -0.0003455 (or something like that) so you would need to validate that the result is between 1 and -1 to accomodate the Date/Time comparison

1 and -1 , did not get it

The best way I've managed this is to make a formula numeric field in your results that just simply is {date1} - {date2} Then you can see the result of what the search is returning Then you know how to properly validate in your criteria tab