Price Book iPhone app Forum

Get solutions for your issues, request new features for the Price Book app.
Date Order is Wrong on CSV « Setup and Configuration « Price Book
 
Sun, 16 May 2010, 09:14am #1
laskater
Member
Registered: May 2010
Last visit: Thu, 27 May 2010
Posts: 1

I just exported my pricebook and noticed the dates were wrong:
01-01-2010 in the app is 10-01-01 in the CSV
05-11-2010 in the app is 10-05-11 in the CSV

Maybe that is how you intended, but if you open in Excel it reverses the dates, and 05-11-2010 becomes 10/5/2011. Can you clarify if this is a bug or how you designed it?

Thanks,
Louis

Offline
Mon, 17 May 2010, 01:06pm #2
admin
Administrator
Registered: March 2010
Last visit: Wed, 01 Feb 2012
Posts: 108

Hi Louis,
I'm a little confused. Can you provide some more details of the process that you followed that caused the date components to get flipped?

Here's what I did:

1) Created a CSV file with the date in the format mm-dd-yy as 09-08-01.
2) Imported the CSV file into the website using the button "Import Standard CSV file".
3) Date appeared on the website as 09-08-01.
4) Imported the data to the Price Book app on my iPhone.
5) Date appeared in the Price Book app on my iPhone as 09-08-2001.

Ooops, got it. You used the "Export by Email" button on the Price Book app
to email yourself a CSV version of the Price Book. OK, I see the error. I
fixed that and sent a new version, 2.4.0, to Apple.

Thanks for catching this!

Kind regards,

Jim

Last edited: Mon, 17 May 2010, 02:10pm by admin

Offline