DicE Posted February 12, 2003 Share Posted February 12, 2003 Hi, I use the 20030203 snapshot, with QCv5.1 and the latest easypopulate. The problem is that the date when a product is going to be available is all wrong. It's correct in my excell sheet, in my tab delimited file. The I upload it through easypopulate with following result: DateAvail was --6/3/2003--DateAdded was ---- | 0702200322 | /xbox Still no problem there. but when I go and look on my site, the date is: 20/03/2006 So as you can see, my dateformat is being changed to the US format YYYY/MM/DD (2006/03/20 and the "03" is just dropped and the date is then reformated to be displayed conform my date formatting. :cry: I think this is due to the QC contribution because when I look at the product detail page in my admin section, I can see there that next to the field to enter the date available, there is a comment that date's must be in YYYY/MM/DD format. I can use the little calendar the to correct the date, but then what's the use of using EP? :wink: Does anyone know where I can change this? It's getting kind of urgent because I can't go live with this ofcourse :( thanks in advance!!!!!!!! Quote _____.:::.________###__________|/______ :(o o): . (o o) (o o) ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo- Link to comment Share on other sites More sharing options...
DicE Posted February 13, 2003 Author Share Posted February 13, 2003 anyone? believe me, I wouldn't be asking if I knew it :? I've looked in the manual, in the forum for the date conversion problem. I've tried them all, but I think this really is a QC issue... is there nobody using this contrib who has the same problem? please help! thank you! Quote _____.:::.________###__________|/______ :(o o): . (o o) (o o) ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo- Link to comment Share on other sites More sharing options...
Elementbuch.de Posted February 13, 2003 Share Posted February 13, 2003 Hi, I think this is due to the QC contribution... i don't think so, because i have the same problem but no QC installed! Quote Link to comment Share on other sites More sharing options...
DicE Posted February 13, 2003 Author Share Posted February 13, 2003 yes but, the strange thing is that all my other dates are correct. date the product was added to the catalog... all of them except that one... same with you? Quote _____.:::.________###__________|/______ :(o o): . (o o) (o o) ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo- Link to comment Share on other sites More sharing options...
wasson65 Posted February 15, 2003 Share Posted February 15, 2003 EasyPopulate doesn't do any date formatting at all, it just pulls the data from mysql, and shoves it into mysql when it's uploaded. So you'll need to put your dates in the uploaded file in the mysql default format, which is YYYY-MM-DD. Tim Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.