May 03 2021 06:12 AM
Hi - I have a field in a report that has date/time information however, I'm having problems with converting this field to a date formatting. I have tried every trick in the book to get it down, including text-to-column.
If anybody could assist - it'd be greatly appreciated. Data example attached.
May 03 2021 06:34 AM
@ncstle If it's just the date date you need, use text-to-columns to separate the date from the time stamp using space as the delimiter. Then select "Date: MDY" as the data type for the date column and skip the time column. You'll end up with a column containing real dates.
Alternatively, use Power Query.
May 03 2021 06:38 AM
May 03 2021 06:46 AM - edited May 03 2021 06:47 AM
@ncstle Actually, am playing around with your table a bit. Try Find & Replace. Find AM and PM and replace with nothing (blank). Fair chance that your Excel will immediately transform the cells to real date/time cells.
If not, I'd go for Power Query. Especially if you need to do this very frequently and on large(r) data sets.
May 03 2021 06:53 AM