Date Format

The excel file I'm using has a date field that lists month, date, year, time

Here is an example:

8/2/2021 1:24:56 PM (displayed in excel as Aug 2, 2021 01:24:56 PM)

However, when I bring the sheet into Alteryx it displays as:

44410.558981

How can I convert this from a V_WString back to a Date field?

Thanks!

Date Time

Help

Time Series

Accepted answers

If its in v_wstring format you can use below formula.

ToDateTime(ToNumber([Field1]))

Hope this helps : )

Try this it.

You can use ToDateTime([Field1])

Workflow:

Hope this helps : )

I'm still getting a [Null] value when I run this formula.

Can you share snapshot of the workflow and is there any warning? If yes can you please share snapshot of that too ?