I am trying to use Select tool to convert my order date into a date formula. However, I got an error saying not a valid date. Why only some of my data is considered not a valid date? The other converts fine
Yes, try using left, right and substring formula. If you will try you will definitely make it work.
after you will amend the column in a proper way you can use select tool to change the format.
Hi @SophieTran,
i assuming you need to swap month with date:
Alteryx uses the ISO format yyyy-mm-dd HH:MM:SS
propably it will star working if you will make some Changes using left, substring and right formula to swap mm and dd.
Do I use the formula tools to change the format before using the select tool?
