Again, having a problem with imports, and the manual offers no suggestions for this. I am importing some Sales Prices into my data base, and am receiving the following error report:

Invalid data '38825' for field called 'Sales Start Date' of...(all records I am wishing to import).

My date on the excel report reads 04/18/06, which is how it is shown in Adagio when I go into this field and manually enter the date. However, I have alot of product codes to update, and import would certainly be much quicker.

Any help would be most appreciated, as this sale is starting this weekend.

Hello Barb9,

As this is really a technical support question, I'll move your post into that forum and answer it there.

Hello Barb9,

Imported dates must have the form "YYMMDD", so that might be one of the problems.

If all the import records are going to get the same start date, consider skipping the field in the import file and setting the field to the date you want using the field default. That way there won't be any format ambiguity.

Hi Barb,

Adagio allows for 3 date formats when importing. You can modify the date format on the import template to match what is in your import file.

- ACSII YYYYMMDD allows a format where either 2 or 4 digit years precede the month/day. Valid formats in the import file are "20060418" or "060418"

- Date simply means the numeric 'julian' date which is the number of days since Jan 1, 1900. This is how excel stores internally, though it can be displayed differently. 38825 is an example of this.

- WinFormat allows the Windows Short Date format to be used, meaning that if you are used to dates in a certain format, you can set this up. Sometimes M/d/yyyy is a format, so "4/18/2006" would be allowed.

It is important to see what the value is in the Excel (or CSV) file, then match the import template field format to that.

Andrew's suggestion of a 'default date' value is good if all records will have the same value.