Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASP Page Using FrontPage 02 With Access DB Results

Status
Not open for further replies.

WildeWebPublishing

IS-IT--Management
Jun 16, 2003
21
0
0
US
I am building a web based search tool using FrontPage 2002 and access 97 that posts the results of an access query.  The search page woks really well but,... When it comes to formatting the results in the ASP post I am having a hard time with Dates and Times.

I want to format the dates not in access but in the scripting of the ASP page.  
Like this---- mm/dd/yy & the time as hh:mm Wihout AM or PM
(the database updates itself from a batch file every fifteen minutes ) So once the site is built I have zero maintenance on it. Once the access db is built I don't want to format it anymore.  Any Ideas.  Thanks in advance.

Here is the script line that give the results of the date. That I want to format.

<!--webbot bot=&quot;DatabaseResultColumn&quot; s-columnnames=&quot;PLNUM,Desc,Surg,Svc,Abbrev,Proc,Last,Times,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,TAvg&quot; s-column=&quot;Last&quot; b-tableformat=&quot;TRUE&quot; b-hashtml=&quot;FALSE&quot; b-makelink=&quot;FALSE&quot; clientside b-MenuFormat preview=&quot;<font size=&quot;-1&quot;>&lt;&lt;</font>Last<font size=&quot;-1&quot;>&gt;&gt;</font>&quot; startspan b-MenuFormat --><%=FP_FieldVal(fp_rs,&quot;Last&quot;)%><!--webbot bot=&quot;DatabaseResultColumn&quot; endspan i-checksum=&quot;3808&quot; -->
 


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top