User Group Leaders:
Find tips to make the most of your User Group experience.LEARN MORE
Please help me with the output for the two columns by removing the zeros after the date. Currently the data type is datetime. I want it to Date data type.
I tried Todate(TrimRight('APPT_END_DT', '0')) and Todate(TrimRight('APPT_START_DT', '0'))
But still giving me the same output. It is not removing the leading zero decimals after the date.
Thanks in advance.
Solved! Go to Solution.
Some of the Alteryx inbuilt functions are really powerful, like the DateTimeParse function, especially if your date are coming in forms of complex strings.
In your case you can use a formula tool with the below expression -
Hopefully, this resolves your issue. Let me know if this isn't what you were looking for.
"Keep Alter-ing Lives"