Issue with Date formatting

[HassimDiallo]

Hello. I am fairly new and eager to become an SME on Alteryx. I am working on Alteryx workflow and I am experiencing the below issues:

i have two string Columns Month (APRIL) and Year (2017) and need to transform them into two additional columns Date (APRIL 2017) and As of Date (04/01/2017). 

For the date column, i am using a Formula ([MONTH]+" "+[YEAR]) which gets me to my desired output.

the issue for As of Date, i am also using a Formula (DateTimeFormat([Date],'%m/%d/%Y')) but all the outputs are returning Null. for the life of me i cannot seem to figure out the issue. all the data are v-String so i thought it should work. Please help!

Kind regards!

[fmvizcaino · Accepted solution]

Hi @HassimDiallo ,

To transform the column monthyear to a date format column, you need to use the datetimeparse function as workflow attached or the datetime tool from the parse category.

The datetimeformat function is used when you want to transform a date column in a string with a specific format.

Best,

Fernando Vizcaino

[rupali_bhise]

Hey @HassimDiallo , 

Attaching reference workflow & screenshot, if it will help you.

Good luck

[RobertOdera · Accepted solution]

Hi, @HassimDiallo 

Try this.

Please mark as acceptable solution + like, if it works for you.

Cheers!

[HassimDiallo]

Thank you @Rupali_bhise for the below. to clarify, I actually need the dateTime_Out output to show as 4/1/2017 and the Date as April 2017. i tried changing the format to MM/dd/yyyy but i am getting a Null output in DateTime_out.

Regards,

Hassim

[HassimDiallo]

Thank you all. Your inputs have been very valuable and helpful!

Regards,

Hassim Diallo

[RobertOdera]

Thank you @HassimDiallo !

I appreciate your feedback.

Let us know if there's anything else you need.

Cheers!