Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Date display as dd/mm/yyyyy


Recommended Posts



I am trying to change the default date display of mm/dd/yyyy (US format) to be dd/mm/yyyy (UK/AU format).


I have gone through a few of the pages where the date is displayed eg.

- product added

- user registration page

but the real problem comes when I try to sign up as a new user and my date of birth is refused because of some SQL error.


Do I need to change something in the database? or is there some global value I can set to get dd/mm/yyyy accepted as the default date???




Link to comment
Share on other sites



not 100% sure but I think your problem is in catalog/includes/languages/english.php .


For a Dutch shop a correct setting could be:

/ look in your $PATH_LOCALE/locale directory for available locales
// or type locale -a on the server.
// Examples:
// on RedHat try 'en_US'
// on FreeBSD try 'en_US.ISO_8859-1'
// on Windows try 'en', or 'English'

// Dutch date settings
setlocale(LC_TIME, 'nl_NL.ISO_8859-1');
// @setlocale(LC_TIME, 'en_US.ISO_8859-1');
// setlocale ('LC_TIME', 'du');
define('DATE_FORMAT_SHORT', '%d/%m/%Y'); // this is used for strftime()
define('DATE_FORMAT_LONG', '%A %d %B, %Y'); // this is used for strftime()
define('DATE_FORMAT', 'd/m/Y'); // this is used for date()

there should be something like that in your language file.


good luck!

Link to comment
Share on other sites

Thanks paulm2003 your suggestion worked :)


I also needed to change the ENTRY_DATE_OF_BIRTH_ERROR conditions so that I could enter dates of birth as dd/mm/yyyy too without an error.




Link to comment
Share on other sites


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

  • Create New...