HOW TO SEPARATE THE DATE AND TIME

[dunkindonut7777]

Hi I have a problem splitting the date field into it's real value. I want to separate the date value from its time value. I have a date value that is string. Sample below:

Date:                                                       Expected output:

01/06/2020  09:00 AM                             01/06/2020

09/78/2020  12:00 AM                             09/78/2020

How can I remove the time in the date field?

Thank you

[sparksun]

Left string function can make it

[cmcclellan]

I'm assuming the data type DateTime (ie not a String), so I would use:

DateTimeTrim([field_name], 'day')