by You can use Javascript to reformat the returned strings. Instead ofQuote:>I need to retrieve date values from an access database and have them
>displayed in the short-date format (10/31/97). Unfortunately, the
>results are returned in the long date/time format (1997-10-31 00:00:00)
>on the pages generated through the htx template. I have specified the
>access table format as short-date in the date's field.
>Does anyone know how to get more formatting control out of the .htx
>template or the SQL query?
passing them to the place on the page where you want them, pass them to a
Javascript function that reformats the strings. Then place a reference to
the Javascript function where you want the reformatted strings to appear.
Hope this helps.
Kevin Spencer
http://www.connectrans.com/takempis
http://members.aol.com/TAKempis
http://www.marketing-solutions.com
http://www.connectrans.com
http://www.connectrans.com/healthfacts
p.s.: I need a job!