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!
Solved! Go to Solution.
If its in v_wstring format you can use below formula.
ToDateTime(ToNumber([Field1]))
Hope this helps : )
Well, my solution only took the date.
Very good @atcodedog05
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 ?
This solution worked! Thanks
Happy to help : ) @patrickcogley
Cheers and have a nice day!