Date Format

[patrickcogley]

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!

[thiago_belarmino]

Hello @patrickcogley 

Try this it.

[atcodedog05]

Hi @patrickcogley 

You can use ToDateTime([Field1])

Workflow:

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @patrickcogley 

If its in v_wstring format you can use below formula.

ToDateTime(ToNumber([Field1]))

Hope this helps : )

[thiago_belarmino]

Well, my solution only took the date.

Very good @atcodedog05

[patrickcogley]

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

[atcodedog05]

Hi @patrickcogley 

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

[patrickcogley]

This solution worked! Thanks

[atcodedog05]

Happy to help : ) @patrickcogley 

Cheers and have a nice day!