Date display as dd/mm/yyyyy

[Guest]

Hi,

 

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???

 

Thanks,

J

[paulm2003]

Hi,

 

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()
define('DATE_TIME_FORMAT', DATE_FORMAT_SHORT . ' %H:%M:%S');

there should be something like that in your language file.

 

good luck!

[Guest]

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.

 

Cheers,

J