Excel Formula

[Abhishekjoshua]

Can someone help me achieve the below excel formula in Alteryx? similarly for month and year as well

[ShankerV]

Hi @Abhishekjoshua 

Please consider the final output as the below. Where I have fine tweaked to work on all different date types.

[ShankerV]

Hi @Abhishekjoshua 

Explaining what happens in my workflow, 

I have used Text to Columns tool, as I see your data is using a delimiter -

Hence the output is split into 3 different columns.

Then the incoming date might be

8-Jan-22

12-Jan-22

15-Jan-2022

the expected output is 

08  Jan  2022

12  Jan  2022

15  Jan  2022

Hence used the formula tool to check the condition whether it contains 2 digits, if not used PadLeft option to add 0 in the front.

Same in year also.

Hope this helps!!!! Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

[Abhishekjoshua]

@ShankerV  I hope this helps, I will try it out and let you know my output. Thank you so much!

[Abhishekjoshua]

@ShankerV  Hi, when the column is spilt into 3, how can I name the 3 columns differently? 

[ShankerV]

Hi @Abhishekjoshua 

[ShankerV]

Hi @Abhishekjoshua 

One more method also, where can use RegEx tool.

By this method, I can reach the solution with just 2 tools highlighted in yellow.