Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

DATE TIME CONVERSION

Highlighted
6 - Meteoroid

Hello All,

 

I'm having a difficult time converting the timestamp below to the Alteryx date time format. 

 

"Thu Feb 28 13:33:46 UTC 2019" 

 

I tried using "dy month dd hh:mm:ss Z yyyy" in the Incoming String field of the DateTime tool, but it only produces nulls. The Example Output field shows the correct format though -  2019-02-28 13:33:46, so I'm not sure why it only produces nulls. 

 

Any help is greatly appreciated. 

 

Thank you,

 

Mark B. 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Ballama6 I mocked up a workflow let me know what you think?

 

Dates_141119.PNG

Highlighted
5 - Atom
I'm bringing in a date field from Excel, in the "07/19/2018" format, and it's a Vstring. I've tried using the DateTime tool, but it says it can't convert "11/01/2019" because the month is not within range 1-12. I used the function DateTimeFormat([Date],"%m/%d/%Y"), and it creates a Vstring date, but even using the ToDate function I can't convert it to a date.
 
I'd like to pull the month out.
I also want to get the week number.
And get the number of days between my dates and today's date.
 
I've tried using the Select Tool to convert to a date but it still gives me a can not convert error.
Highlighted
Alteryx
Alteryx

See attached for an example. I used the datetime tool to convert the string to a date format. Then I used the formula tool to derive the month, week, and difference values. Let me know if that works! 

Highlighted
5 - Atom

The datasets I am blending have different date formats- one is MM/dd/yyyy hh:mm:ss and the second is yyyy-MM-dd. I've had to use the Select tool to format them as String then use the Date tool to format them as dates in their respective format.  Then I used the Date tool to convert them back in to String with the same yyyy-MM-dd format for blending.

 

But my formulas to pull the Month, Week number, and difference in days I built individual for each data set. I couldn't get the formulas to work on the blended date field.

Labels