community
cancel
Showing results for 
Search instead for 
Did you mean: 

Bengaluru, IN

Bengaluru Alteryx User Group - A great platform to collaborate, learn, network, experiment, grow, drive impact on the community/charities and much more! Be part of the passionate group of people who are destined to create one of the best analytics community across the globe and also impact the community through Analytics. Are you ready for this journey?

User Group Leaders:

Yugandhar Muley (Yug) Subrat Das Jerrin Thomas Manjunath Shastry Sharon Stephen

Welcome & Guidelines

Find tips to make the most of your User Group experience.

LEARN MORE
Reply
This is an open group. Sign in and click the "Join Group" button to become a group member and start posting.
Highlighted

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

Asteroid

Capture.jpg

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.

2 REPLIES 2
Meteor

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

Asteroid

@sreenivasateja 

 

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.


Sol.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

--

Best,

Raghav

"Keep Alter-ing Lives"