remove zeros (hh:mm:ss) after the date.

[stj1120]

Hi all,

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.

Best Regards,

Sreenivasa Teja.

[Manjunath · Accepted solution]

Hi Sreenivas,

Could you try adding a select tool after the data and changing the data type to "Date" instead of "DateTime" ? That should do the trick

[rag-ryx · Accepted solution]

@stj1120 

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 - 

DateTimeParse([APPT_END_DT],"%y-%m-%d")

Hopefully, this resolves your issue. Let me know if this isn't what you were looking for.

--

Best,

Raghav

"Keep Alter-ing Lives"