Hello everyone,

I'm trying to integrate UPS and our inventory system using Crystal. I have everything set up properly but I'm having one problem that I'd like to try and fix.

One of UPS's values in their database is called "Collection Date", which is a date/timestamp of when a waybill was printed. I'd like to use this value as a shipping date, however the way that they have the record structured is not really helping; they put the date and time in one long number string. For example, if the date was August 20th, 2008, printed at 2:14pm with 15 seconds, the string would read: 20080820141415.

Is there any way that I can break up this one string so that I can display the date only? And preferably structure it in a way that I can have the date displayed in yyyy/mm/dd format?

Thanks in advance for any replies.

Thanks for your reply, however since I use Crystal Reports maybe once every six months then I wouldn't have much use for the book, although i'm sure it's very good.

This is the formula that I'm now using:

if {UPS_CSV_EXPORT_csv.TRACKING NUMBER} = "" then "Not Shipped" else mid(totext({UPS_CSV_EXPORT_csv.SHIP DATE}),4,2) & "/" & mid(totext({UPS_CSV_EXPORT_csv.SHIP DATE}),6,2) & "/" & left(totext({UPS_CSV_EXPORT_csv.SHIP DATE}),4)

The value in the CSV file is: 20080829113825
The value that Crystal reports back is: 08/0,/20,0

Very bizarre. Any ideas?

Thanks,
Travis