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?
Solved! Go to Solution.
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!
That helped - thank you!