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

Alteryx designer Discussions

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

date field import from excel

Meteor

hi Alteryx community

 

I am importing an excel file, which has a date in a specific field (e.g: 30.04.2019). The cell with the date references a different cell (e.g. ='H4') and both cells are formatted as "Date" in the Excel.

 

When I import the file into Alteryx, the date field changes to "1900-01-29 00:57:36". 

 

Any idea why that happens?

 

Thank you.

Alteryx
Alteryx

@janez_007 

 

Can you share the value in H4?

Aurora

Hi @janez_007 

 

Even better than @MichalM's idea, would be if you could share an entire sample sheet with just the 2 date columns

 

Dan 

Meteor

hi

 

sure, attached please find the Excel. The date I want to "extract" is on "sheet2", column "AAA", row nr 3.

 

Thank you. 

Labels