Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Formatting issue returning wrong results

gobluerob
5 - Atom

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.

2 REPLIES 2
Rhys_Cooper
9 - Comet

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
9 - Comet

@gobluerobany progress with this?

Labels
Top Solution Authors