Possible help with Date time tool

Hi All,

My input data containing a column of datetime, example: "07/31/2025 1:41PM" which needs to be changed as "07/31/2025".
i tried with datetime tool (customize) %m/%d/%y %I:%m%p. so in a new column its gives output for few of the cells, but rest of them were blanks. Please advise, if customize was incorrect or is there is an alternative method to achieve the same output (example: 07/31/2025) ?

Thank you

Input

Output

Date Time

Accepted answers

davidskaife

Hi @AgiGovind

You were close, you need to uppercase the code for Year, and for Minute - use a Formula tool and apply this code to first change it to the ISO Standard Format using DateTimeParse, then wrap it in a DateTimeFormat to change it to just the specific date format you require:

DateTimeFormat(DateTimeParse([Date],'%m/%d/%Y %I:%M%p'),'%m/%d/%Y')

Date Format.yxmd

All comments

unknown

@AgiGovind If you only need the date just use the "text to column" tool. Use \s as delimeter.

Gaurav_Dhama_

You can use DateTime Parse tool to convert the incoming datetime field to Alteryx standard DateTime field. Once you get that, add a select tool and change the data type to Date from DataTime. This will give you your desired value. Snip below.

Parse Configuration:

MM-dd-yyyy HH:mm

Select tool config:

davidskaife

Hi @AgiGovind

DateTimeFormat(DateTimeParse([Date],'%m/%d/%Y %I:%M%p'),'%m/%d/%Y')

Date Format.yxmd

aatalai

Similar to @davidskaife used a formula tool, but trimmed the string then used datetime parse

DateTimeParse(left([Field1],10),"%m/%d/%Y")

Screenshot 2025-08-01 110623.png

Possible help with Date time tool.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703