Forum Discussion
Joe_TaylorSolarJT
Mar 10, 2022Copper Contributor
Help Removing Time Stamps
I need help removing this odd time stamp from my dates. There is no space between the formatted date and time. Example: 2022-03-09T10:00:00:00Z
Riny_van_Eekelen
Mar 10, 2022Platinum Contributor
Joe_TaylorSolarJT Try Text-to-columns, with "T" as the delimiter. In step 3, set the data type for the first column to YMD and the second column to Skip. If all goes well you'll end up with one column of properly formatted dates.