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.
Solved! Go to Solution.
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.
@JosephSerpis Or Anyone here ,
can you guys help me converting '2021-11-24T13:55:50.930-0800' this to date and time format.