DATE TIME CONVERSION

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.

2019-11-13_19-04-24.png

2019-11-14_15-17-39.png

Date Time

Accepted answers

JosephSerpis

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

Dates_141119.yxmd

All comments

JosephSerpis

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

Dates_141119.yxmd

CJBioS

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.

rrikkala

@JosephSerpis Or Anyone here ,

can you guys help me converting '2021-11-24T13:55:50.930-0800' this to date and time format.

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335