<% @ Language=VBScript %> <% Option Explicit %> <% 'Set the response buffer to true Response.Buffer = True 'Dimension variables Dim strMode 'holds the mode of the page, set to true if changes are to be made to the database Dim strDateFormat 'Holds the date format Dim strYearFormat 'Holds the year format Dim intTimeFormat 'Holds the time format Dim strDateSeporator 'Holds the date seporator between the day/month/year Dim saryMonth(12) 'Array holding each of the months Dim strMorningID 'Holds the identifier to show for morning in 12 hour clock Dim strAfternoonID 'Holds the identifier to show for afternoon in 12 hour clock Dim intMonthLoopCounter 'Loop counter for the months 'Initalise the strSQL variable with an SQL statement to query the database strSQL = "SELECT " & strDbTable & "DateTimeFormat.* From " & strDbTable & "DateTimeFormat;" 'Set the cursor type property of the record set to Dynamic so we can navigate through the record set rsCommon.CursorType = 2 'Set the Lock Type for the records so that the record set is only locked when it is updated rsCommon.LockType = 3 'Query the database rsCommon.Open strSQL, adoCon 'If the user is changing the date/time setup then update the database If Request.Form("postBack") Then With rsCommon 'Update the recordset .Fields("Date_Format") = Request.Form("dateFormat") .Fields("Year_format") = Request.Form("yearFormat") .Fields("Time_format") = Request.Form("timeFormat") .Fields("Seporator") = Request.Form("seporator") .Fields("am") = Request.Form("am") .Fields("pm") = Request.Form("pm") 'Upadet the months (arrays start at 0 in VBScript but for simplisity we are not using location 1) For intMonthLoopCounter = 1 to 12 .Fields("Month" & intMonthLoopCounter) = Request.Form("month" & intMonthLoopCounter) Next 'Update the database with the new user's details .Update 'Re-run the query to read in the updated recordset from the database .Requery End With 'Empty the application level array holding the date and time format so that any changes are visable in the main forum Application("saryAppDateTimeData") = null End If 'Read in the deatils from the database If NOT rsCommon.EOF Then 'Read in the date/time setup from the database 'Update the recordset strDateFormat = rsCommon("Date_Format") strYearFormat = rsCommon("Year_format") intTimeFormat = CInt(rsCommon("Time_format")) strDateSeporator = rsCommon("Seporator") strMorningID = rsCommon("am") strAfternoonID = rsCommon("pm") 'Update the months (arrays start at 0 in VBScript but for simplisity we are not using location 1) For intMonthLoopCounter = 1 to 12 saryMonth(intMonthLoopCounter) = rsCommon.Fields("Month" & intMonthLoopCounter) Next End If 'Reset Server Objects rsCommon.Close Set rsCommon = Nothing adoCon.Close Set adoCon = Nothing %> FORUM DATE & TIME SETTINGS

From here you can configure the format of date and time settings in the forum.

DATE SETTING
DATE FORMAT :	>Day/Month/Year >Month/Day/Year >Year/Month/Day >Year/Day/Month
SEPARATOR : This is the separator between the date eg: 12/12/2003, 12-12-2003, etc.	><space> >/ >\ >- > -  >.
YEAR FORMAT : This is whether you want the date in 4 digits (2003) or in 2 digits (02)	>yyyy >yy
JANUARY* : This is what you would like displayed for January eg: 01, 1, Jan, etc.
FEBRUARY* :
MARCH *:
APRIL* :
MAY* :
JUNE* :
JULY* :
AUGUST* :
SEPTEMBER* :
OCTOBER* :
NOVEMBER* :
DECEMBER* :
TIME SETTING
TIME FORMAT : For 12 hour clock set to 12 for military time (24 hour clock) set to 24	>12 Hour Clock >24 Hour Clock
MORNING IDENTIFIER FOR 12 HOUR CLOCK TIMES : example: am
AFTERNOON IDENTIFIER FOR 12 HOUR CLOCK TIMES : example: pm