Database Results Wizard

[SS]

Hi

I have form that gives the results from a database but the Timestamp appears
in the USA date format eg month/day/year. Although in the database it
appears day/month/year. How can I get the results to show this format.

My regional settings are correct

Cheers
Shona

 

[Thomas A. Rowe]

You will have format the date display using the code shown at:
http://www.codefixer.com/tutorials/dates_times.asp

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[SS]

So what do you know what I change in this

<!--webbot bot="DatabaseResultColumn" startspan

s-columnnames="ID,NewUser,Leaver,Existing,SugUserName,ExistUserName,Replacem
ent,ReplacementName,CostCentre,Site,FirstName,MI,LastName,Position,DeptName,
DeptNo,Employment_Type,TempLeaveDate,StartDate,LeaveDate,Email,Email_Code,Te
lNo,CopyUser,DriveLetter1,DrivePath1,IncSubFolders1,ReadWrite1,ManAuthorise1
,DriveLetter2,DrivePath2,IncSubFolders2,ReadWrite2,ManAuthorise2,DriveLetter
3,DrivePath3,IncSubFolders3,ReadWrite3,ManAuthorise3,DriveLetter4,DrivePath4
,IncSubFolders4,ReadWrite4,ManAuthorise4,DriveLetter5,DrivePath5,IncSubFolde
rs5,ReadWrite5,ManAuthorise5,DriveLetter6,DrivePath6,IncSubFolders6,ReadWrit
e6,ManAuthorise6,RequestBy,ReqbyTel,ManAuthorise,AuthManEmailAddress,Comment
s,Remote_computer_name,Browser_type,Timestamp,EmailDis"
s-column="Timestamp" b-tableformat="FALSE" b-hasHTML="FALSE"
clientside
local_preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Timestamp&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Timestamp&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_r
s,"Timestamp")%><!--webbot
bot="DatabaseResultColumn" endspan i-CheckSum="20579" -->

Not quite sure where to put <%= Date() %> as I want to pick up the Timestamp
from the database.

Cheers Shona

 

[Thomas A. Rowe]

Using <%= Date() %> will pull the date from the server's time and not your database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Willem]

Hi, in global.asa insert in the Sub Session_OnStart incluse a line
Session.LCIS=2057 (or top of each asp page <% Session.LCID=2057%>.). This
will convert each session LCID to the UK (=2057). You can find the LCID's for
your country in MSDN (search for LCID). South Africa (7177) however does not
yield the required results, but the UK (2057) does. Whereever you issue a
database instruction for your date, use CDATE e.g:
Set prmBy28d = cmdd.CreateParameter("@BirthDate", 135, 1, 0,
CDATE(Request("BirthDate")))
cmdd.Parameters.Append prmBy28d
Good luck. This solution took me about a month to research and implement.
Although in SA, the UK's LCID works fine. Must tell Tony Blair that something
of the UK does work in Africa.