Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate Date


glamourfish

Recommended Posts

Does anybody know what format the date needs to be when using easy populate?

 

e.g:

 

06/12/2006 (day/month/year)

12/06/2006 (month/day/year)

06/12/06 (day/month/year - 2 digits)

12/06/06 (month/day/year - 2 digits)

2006/12/06 (year/month/day)

 

ETC ETC ETC........ I keep getting the wrong date entered & think I have my format wrong!

if at first you do succeed...try not to look surprised!

Link to comment
Share on other sites

yyyy-mm-dd

 

In excel, highlight the column, right click, format, custom, yyyy-mm-dd

 

Does anybody know what format the date needs to be when using easy populate?

 

e.g:

 

06/12/2006 (day/month/year)

12/06/2006 (month/day/year)

06/12/06 (day/month/year - 2 digits)

12/06/06 (month/day/year - 2 digits)

2006/12/06 (year/month/day)

 

ETC ETC ETC........ I keep getting the wrong date entered & think I have my format wrong!

Link to comment
Share on other sites

Brilliant...thx a million!

 

Do you know if one can edit the date added after you have uploaded a product & the date is incorrect...as in my case?

if at first you do succeed...try not to look surprised!

Link to comment
Share on other sites

Yes, you can fill in any date you like in the v_date_added column (formatted as described above), and it will adjust the date added in the database, and fix the...

 

"This product was added to our catalog on ...." phrase on the product_info.php page.

 

 

 

Brilliant...thx a million!

 

Do you know if one can edit the date added after you have uploaded a product & the date is incorrect...as in my case?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...