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
Solved! Go to Solution.
@Adam_B The Action Date is already in the DateTime format
@binuacs 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.
@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
@binuacs The example file is a just that. My actual data file is a CSV and it is showing V_WString
@Adam_B in that case use the DateTimeParse() function
@binuacs THANK YOU!!!!!