Formatting issue returning wrong results

[gobluerob]

Apologies for the seemingly basic question.  I inherited a workflow where one of the outputs is simply counting items still open that were created before the most recent month.  For example, its January so count items created in November (and before) which are still open.  The problem is, ALL open items are being counted.  the date format in the first record is correct but all the other dates are formatted incorrectly.  I'm not getting an error but shouldn't Alteryx verify all the records for formatting and not just the first one?  it's been happening for over a year but no one noticed since there were no errors.

[Rhys_Cooper]

It is possible the DatetimeParse tool has bugged and incorrectly formated the dates which I have seen quite a few times on 2023 designer versions. IF this is the case, i reccomend replcating the formatiing in a formula tool instead.

Regards - Rhys

[Rhys_Cooper]

@gobluerobany progress with this?