concat string columns to create a date variable

[himam]

Hello everyone, 

I have the first 3 columns as shown below and what to create the 4th column i.e. EVALUATION_DATE2

EVAL_DT	EVAL_MO	EVAL_YR	EVALUATION_DATE2
5	10	2022	10/03/2022
31	3	2021	11/03/2021

I tried the following but got the error saying "EVALUATION_DATE2: "3/31/2021" is not a valid Date"

Thanks in advance!

[BS_THE_ANALYST]

Hi! To have the date as a date datatype, it needs to be in the following format: yyyy-mm-dd. 

See picture below:

You could solve your problem by changing your Evaluation_Date2 datatype to V_WSTRING and then connecting the DateTime tool to it. You'll be able to format it correctly there! :-) 

[BS_THE_ANALYST]

try this workflow out, it's one way to do it. Attached it workflow

[BS_THE_ANALYST]

@himam another possible way: you can actually use the DateTime tool functionality inside the formula tool 

[Sarreddy]

@himam 

[Sarreddy]

@himam 

[JenzEkan]

g

[grazitti_sapna]

@himam , Please find my response to your problem

Alteryx Supported Date Format: YYYY-MM-DD