Hello everyone, I have the first 3 columns as shown below and what to create the 4th column i.e. EVALUATION_DATE2 EVAL_DTEVAL_MOEVAL_YREVALUATION_DATE2510202210/03/2022313202111/03/2021 I tried the following but got the error saying "EVALUATION_DATE2: "3/31/2021" is not a valid Date" Thanks in advance!

concat string columns to create a date variable

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!

Datasets

Parse

Date Time

Accepted answers

All comments

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

eval_sol.yxmd

BS_THE_ANALYST

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

@himam , Please find my response to your problem

Alteryx Supported Date Format: YYYY-MM-DD

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703