That's a good question. I'm not sure what is the answer to that question. I'll do some research and get back to you if I got an answer. You should email the people at iPage as they probably could answer your iPage question..
What is the format of the date? EP requires YYYY-MM-DD to work properly..
I'm writing in format as you said YYYY-MM-DD and then I import via Easy Populate..
But nothing happens... the date is not put on the products..
If I open the EP file in excel - the date format has changed to 07-07-2004 00:00.
(I entered 2004-07-07 00:00 ).
So somehow I think excel is messing up the format..
Does anybody have an idea how to correct this ?
Excel isnt messing it up, it is how you have dates defined in excel. for further help with ep, you are best to post at the end of the ep support thread,.
It may not be a matter of Excel messing it up, just the way it works. I have to reset the date format everytime I open a catalog file since I cannot get it to save the custom format. I've asked here, on the forums, as well as on an Excel list and no one knew how to make it save the custom format. I find it hard to believe that it cannot but that seems to be the case..
I got the excact same problem now, I got I working - but only until the next time I do an import... then I have to redo the date format.... annoying :-(..
I think I found the solution:.
The default way dates and times are displayed by Excel (and in the system generally) can be changed at the Windows level, if you have the privileges (you don't have them on the public PCs). In Windows 98 onwards, you can also amend the default settings for 2-digit year interpretation (from 1930-2029). If you want to alter these settings you need to go to the Control Panel files. DO NOT CARRY OUT THE FOLLOWING INSTRUCTIONS UNLESS YOU NEED TO:.
From the Window's Start button choose Settings then Control Panel.
Double click on the Regional Options (or, in Windows 98, Regional Settings) icon.
On the Date tab you can set up a format for both short and long date styles and you can change the date separator (e.g. from a slash to a hyphen). In Windows 2000 onwards you also have a When a two-digit year is entered, interpret as a year between: box.
On the Time tab you can set up the Time format: and you can change the Time separator: (from a colon..