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
Left string function can make it
I'm assuming the data type DateTime (ie not a String), so I would use:
DateTimeTrim([field_name], 'day')