community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

how to output to excel as datetime column format, using table and render tool?

Hi,

I can't figure out how to output datetime values to excel using the table and render tool, so that excel recognizes the values as a proper date time format, so excel users can build pivot tables using the date time values?

 

When outputting to excel using table and render tool, opening up the excel file recognises it as a number?

 

If outputting to excel using the normal output tool, then it works fine.

 

examples below, appreciate your help,

Ryan

 

example test using a text tool with 1 datetime value, along with table and render tool:

example datetime output.PNG

excel.PNG

 

 

example test using text tool with normal output tool

 

example datetime output 2.PNG

excel 2.PNG

 

 

 

 

 

Moderator
Moderator

Hi @RyanNewsome,

 

I tested this on my machine and I see the same outputs as you do (excel recognizing the same data as different field types depending on output format).  

 

However, I tested with some date functions on each output type and excel seems to recognize my outputs as a date field (can perform date calculations on the date field I created in Alteryx).

 

If you take the output of the render, and apply a date calculation to it in excel do you get errors?

Jess Silveri
Premium Support Advisor | Alteryx

Hi Jessica,

 

Thanks for testing.

 

I can't get date functions to work in excel? Are you outputting a datetime value from Alteryx?

 

I tried to do a DATEDIF and get #NAME? error

 

I tried using the date column in a pivot table, dragged it to rows, and it doesnt detect it as a date i.e. show years/quarters/months drop downs.

 

If you can get DATEDIF or pivot table to work with your output, could you please send me your workflow?

 

Thanks,

Ryan

Moderator
Moderator

Hi Ryan,

 

Workflow attached.  I output my field as a datetime format using table and render to excel 2007 spreadsheet.

 

I then used formula:  =DATEDIF(A3,A2,"D")  on the spreadsheet without doing any reformatting in excel and it returned '1'

 

Thanks,

 

Jess Silveri
Premium Support Advisor | Alteryx

Not working for me.  According to Alteryx's Browse Tool, the date field is being changed to a V_STRING.000011.jpgfield starts as DateTime000012.jpgTable Tool changes field to V_String

Labels