Date comparison (without time&hour)

[Anonymous]

Hello,

I've stored two dates in my DB in the classic Date&Time format and I'd like to compare them not considering the Time part, but only the day one  (eg 23/10/17 13:30 should be compared with 23/10/17 13:31 and the result must be that they are equals).

Thank you for the help.

N.

[Or]

Dayname(Date1) = Dayname(Date2) is easiest. You could also use Floor(), or any number of other options.

[Anonymous]

Thank you Shoham for the prompt reply and for the aswer!

I've lost a lot of time looking for it!

N.