Forum Discussion
ncstle
May 03, 2021Copper Contributor
text to date formatting issue
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, inclu...
ncstle
May 03, 2021Copper Contributor
I do need both the date and time. Do you have have any suggestions to resolve this that includes both?
JMB17
May 03, 2021Bronze Contributor
I don't think your data is in a proper time format as there is no space between the time and the AM/PM. Try doing a find/replace (ctrl+h) on your actual delivery column and add a space by replacing "AM" with " AM" and "PM" with " PM" (without quotes - I used the quotes so you can seep where the space is).