Date Formatting issue in Output data

[viral_gada]

Hi,

Can anyone help me in the Date formatting issue in Alteryx.

While running workflow, I changed the string type to Date, but the date column shows as text in excel,

Refer current stage picture

I tried using Formula tool with function as Datetimeformat([Date],'%d-%b-%y') , but it didn't work.

I need the output of excel as per attached. Thanks in advance !

[gautiergodard]

Hello @viral_gada 

This may be due to a data type you are passing through in Alteryx.

I replicated this scenario in the attached workflow and was able to render the dates in the format you are looking for.

See attached for example.

Hope this helps! 

[viral_gada]

Thanks @gautiergodard for the help here !

I tried this but in my workflow after Date/Time tool, I am using Basic Table tool & then in the end using layout tool & Render tool as well due to which the output is getting changed to text again.

Could you help on this issue?

[gautiergodard]

Hey @viral_gada 

Got it, that is important difference to call out!

This is a limitation created by excel, and it is documented in the following thread by @DawnDuong :

Date exported by Render from Basic Table is not in... - Alteryx Community

Depending on what you are trying to do, you may want to consider simply using an output tool to export your outputs instead of the tools in the reporting tool pallet.