Date format keeps changing to US format (1 Viewer)

Portucale

Registered User.
Local time
Today, 17:21
Joined
Sep 7, 2012
Messages
32
Hi,
Please accept my apologies if I am posting this issue in a wrong place but not sure what to do anymore. I am trying to provide some analysis on HITS into a particular web page, the same is connected to a Access Database.

I have a asp page which is connected to a access database only extracting the USER ID and DATE/TIME, however for some strange reason the date keeps changing to the US format, I have searched and seen so many possible solutions but for the eck of me, I can't make the problem go away.
Below is the code that I use in the asp page:
<%
' simply return the username and domain from the server var
Dim sluDomainUser : sluDomainUser = Trim(Request.ServerVariables("LOGON_USER"))
Dim sluUserIDSlash : sluUserIDSlash = InStr(sluDomainUser,"\")

'Strip off domain and this becomes User ID
sluUserName = LCase(Mid(sluDomainUser, sluUserIDSlash+1))

'Remove domain
sluDomain = UCase(Left(sluDomainUser, sluUserIDSlash-1))


' ok lets create a session record
sql = "INSERT INTO tblUserLogFAQ (ulUserid, ulDateTime) VALUES ('" & sluUserName & " ', #" & Now() & "#)"
If dbQuery(rs, sql)=False Then
' we have been unable to record user id
Response.Write("Error")
Response.End()
End If
' End the session
Call EndRoutine()
%>
and again part of the extract from Access

ulUserID ulDateTime
dse31 29/08/2012 15:02
cra04 29/08/2012 15:53
cra04 29/08/2012 16:09
she77 29/08/2012 17:16
lcn01 30/08/2012 09:08
thd02 30/08/2012 12:21
vdf01 30/08/2012 13:05
dem78 30/08/2012 19:59
dav39 31/08/2012 11:21
jam32 31/08/2012 21:47
bky01 09/01/2012 15:10
adn22 09/01/2012 15:11
mil06 09/01/2012 17:42
brs08 09/01/2012 22:18
tak73 09/02/2012 15:42
tak73 09/02/2012 15:44
tak73 09/02/2012 15:44
jys03 09/02/2012 19:22
vig01 09/02/2012 19:48
csa61 09/03/2012 09:19
vdf01 09/03/2012 09:25
vdf01 09/03/2012 09:32
vdf01 09/03/2012 09:33
hap88 09/03/2012 12:29
aal81 09/03/2012 13:07
jll05 09/03/2012 14:38


What is also strange is that only happens for the first 12 days of the month... which makes me think if there is anything wrong with the asp code.

Any help will be very much appreciated.

Vitor da Fonseca
 
Last edited:

Users who are viewing this thread

Top Bottom