Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

HOW TO SEPARATE THE DATE AND TIME

dunkindonut7777
8 - Asteroid

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

2 REPLIES 2
sparksun
11 - Bolide

Left string function can make it

sparksun_0-1631069535703.png

 

cmcclellan
13 - Pulsar

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

 

DateTimeTrim([field_name], 'day')

Labels