WildeWebPublishing
IS-IT--Management
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="DatabaseResultColumn" s-columnnames="PLNUM,Desc,Surg,Svc,Abbrev,Proc,Last,Times,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,TAvg" s-column="Last" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Last<font size="-1">>></font>" startspan b-MenuFormat --><%=FP_FieldVal(fp_rs,"Last"%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3808" -->
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="DatabaseResultColumn" s-columnnames="PLNUM,Desc,Surg,Svc,Abbrev,Proc,Last,Times,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,TAvg" s-column="Last" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Last<font size="-1">>></font>" startspan b-MenuFormat --><%=FP_FieldVal(fp_rs,"Last"%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3808" -->