UBB.threads PHP Forum Software Community Forums Resources and Customizing How Do I? Date Format - possible to change across the board?

I created accounts for all 200 or so of our employees under the assumption that what I'd selected as the default date/time format (under UBB display settings) would also be the default for each user when logged in. I just found out that every one of them has it all set up differently (European style, with the day first) - do I really have to edit every single person's settings, or have every single person do it themselves? Is there any way to change all users' settings to the same date format by default?

Thanks for your help.

Log in as administrator and in the control panel under "Tools & Info" click on "Database Tools", then click on the "SQL Command" tab.

Cut and paste the following into the Query box, then click the "Execute" button:

update ubbt_USER_PROFILE
set USER_TIME_FORMAT = 'd/m/y | h:i A'

You can run the following to change the default for new users to that format:

alter table ubbt_USER_PROFILE
change USER_TIME_FORMAT USER_TIME_FORMAT varchar(30) not null default 'd/m/y | h:i A'

or in the control panel select under "Display Options", "General", then click on the "Date & Time" tab. You can paste the desired date & time format into the "Default Time Format" field.

Sorry for the belated reply - I meant to tell you that this worked wonders. THANK YOU!