We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

How can I Remove HH:MM:SS from a Date Format using Formula Tool

Karl_Spratt
8 - Asteroid

Hi Community,

How can I Remove HH:MM:SS from a Date Format using Formula Tool

Example in my column L_CREATION_DATE the Date is coming as 22/02/2023 14:51:19  I want to show it as 22/02/2023 how do I do this can someone please explain 

 

TIA,

Karl. 

 

3 REPLIES 3
DataNath
17 - Castor

Hey @Karl_Spratt, although you could parse and reformat the DateTime, if the field format is consistent then you could just pull the left 10 characters that cover the date:

 

DataNath_0-1679562208011.png

SmitaLohande
8 - Asteroid

Hi @Karl_Spratt,

 

If the date input is Datetime format, you can simply add a select tool and change its datatype in the tool to Date. This should work.

SmitaLohande_0-1679562757959.png

SmitaLohande_1-1679562776265.png

 

 

Else, if the datatype of input is String, use the 'DateTime' tool from 'Parse', change it to datetime, and then use select tool. Within select you can change the data type to 'Date' as in the above snip.

 

This is the configuration for the 'DateTime' tool:

SmitaLohande_2-1679562937268.png

 

Please like or mark it as solution if it helped :)

Karl_Spratt
8 - Asteroid

Thanks all for your help, it was in Date/Time, so changing to just Date worked.

Thanks again Community for all your help here.

 

Regards,

Karl. 

Labels