Data Time Output not working

Hello,

I have searched Alteryx support topics and documents before coming to the discussion to ask this question.

I have an Action Date field that is MM/dd/yyyy hh:mm:ss and I am using the Convert Action Date tool to try and convert it to a Date/Time format. The Output is null (100%) and I cannot figure out what I am doing wrong. Please see attached for data example and screenshot of the Covert Action Date tool. Please help.

Thanks,

Adam

Screenshot 2024-03-26 105306.png

Example_032624.xlsx

Transformation

Accepted answers

binu_acs

@Adam_B The Action Date is already in the DateTime format

jsamstad

Alteryx already reads the column as DateTime. You can convert it to a string if you desire using the DateTime tool or leave it as is.

Screenshot 2024-03-26 100152.png

binu_acs

@Adam_B in that case use the DateTimeParse() function

All comments

binu_acs

@Adam_B The Action Date is already in the DateTime format

jsamstad

Alteryx already reads the column as DateTime. You can convert it to a string if you desire using the DateTime tool or leave it as is.

Screenshot 2024-03-26 100152.png

Adam_B

@binu_acs It is a String, I need to convert the field to the Date/Time

Screenshot 2024-03-26 110303.png

Adam_B

@binu_acs Not sure I understand, the select tool still shows it as a V_WString post convert Action tool. The select before the Convert Action Tool shows as a V_WString.

binu_acs

@Adam_B Are you reading from the excel file or from the text input? If you are using the input file as your excel then it would read as DateTime type

DateType_26032024.yxzp

Adam_B

@binu_acs The example file is a just that. My actual data file is a CSV and it is showing V_WString

binu_acs

@Adam_B in that case use the DateTimeParse() function

Adam_B

@binu_acs THANK YOU!!!!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703