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

[Karl_Spratt]

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. 

[DataNath]

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:

[SmitaLohande · Accepted solution]

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.

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:

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

[Karl_Spratt]

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.