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
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
9 - Comet

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
Top Solution Authors