Date Formatting issue in Output data

Question

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 !

current stage.png

Expected result.png

gautiergodard · Answer

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.

viral_gada · Answer

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 · Answer

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!

datetest.yxmd