Comparing dates only, not the timestamp

Jake5

Hello,

I'm trying to compare to two dates using *M/DD/YYYY format.  My objective is to filter out scenarios where one date is > than the other.  However, I'm noticing scenarios where the dates match and it's still filtering out.  I believe this is happening because Alteryx is taking into consideration the time stamp.  How do I remove the timestamp from consideration and have it just evaluate the date?

Denise_Santos

Hi @Jake5,

You'd need to remove the timestamp from your DateTime field. You can easily do this by using a formula tool (see below). From there, you can use the DateTime tool to format your date field in a way that can be used for comparison with another date field.

I've attached the workflow below as an example. Hope this helps!

Date Formatting Comparison.yxmd