Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hi,
I have a date in excel but in Alteryx it switch to double. I want to keep it a date.
In Alteryx What I am trying to get
(this is how it is in the excel file when I input it)
Solved! Go to Solution.
Try using the following and see how you get on:
datetimeformat(ToDateTime(tonumber(<Insert field name>)), '%B %d, %Y %I:%M:%S %p')
The ToNumber() may not be needed in your case. If not, just remove that and try:
datetimeformat(ToDateTime(<Insert field here>), '%B %d, %Y %I:%M:%S %p')
Iirc, Alteryx can't handle milliseconds, though I may be mistaken.
