Data Format issue in Alteryx

[SH_94]

Hi,

I have chosen the field type as date as shown as screenshot below and it show the null result.

May i know how can we fix this?

[mceleavey]

Hi @SH_94 ,

Can you post your workflow with a mock up of your data showing the exact format in which the date field is coming in originally?

M.

[SH_94]

Hi @ mceleavey 13 

Kindly find the file below for your reference..

Can you please let me know what are the errors or step that i missed?

Thank you.

[ImadZidan]

@SH_94 ,

mate, you are creating the issue. On the select tool, you have explicitly changed the data type of the Transdate from VString to Date, this is the issue. make the change after the formula tool and that should work.

[SH_94]

Thanks a lot again for your help

[SH_94]

Hi @ImadZidan,

May i know what formula i should use if there are two format inside the data as show below?

[grazitti_sapna]

Hi @SH_94,

Is this what you are looking for?

If it solves your issue please mark it as a solution

[SH_94]

Hi @ grazitti_sapna 15

Kindly find the file below for your reference.

[SH_94]

Hi @grazitti_sapna

If you look at the output , the date for second row is different . Meaning the year from input is 2019 but the output is 2022

Yes. This is what i looking for but may i know how to fix it ?

[grazitti_sapna · Accepted solution]

Hi @SH_94,

Here is what you can do to solve this issue.

I hope it solves your issue.

[SH_94]

Hi @ Sapna,

I have tried using the formula that shared with you but it give the output as shown below.

For those with 14/02/2020, it has been successfully changed it to 2020-02-14. But for those date original in the format like 2021-04-15, it change to number as shown in the screenshot below. May i know how should i change it accrodingly?