Wrox Programmer Forums
|
ASP Forms As of Oct 5, 2005, this forum is now locked. Please use "Classic ASP beginner" at http://p2p.wrox.com/forum.asp?FORUM_ID=54 or "Classic ASP Professional" http://p2p.wrox.com/forum.asp?FORUM_ID=56 instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP Forms section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 3rd, 2003, 10:37 AM
Authorized User
 
Join Date: Jul 2003
Posts: 41
Thanks: 0
Thanked 1 Time in 1 Post
Default extra date info from query

Strangest thing...dates in our access db are entered into the db like "7/11/2003"
When I do a query from a web page using the following code: <%=rs("Vdate")%> (Vdate = Voucher Date), I get a full date something like "7/11/2003 8:15:43 AM".

Not sure what's going on here and really don't care...how do I format my <%=rs("Vdate")%> to get rid of the extra baggage?

thanks

 
Old December 4th, 2003, 09:45 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

You can either use FormatDateTime function (which doesn't have many options) or use the Year(), Day() and Month() functions to build your own format.





Similar Threads
Thread Thread Starter Forum Replies Last Post
XML export from query info Coby Access VBA 0 September 20th, 2007 02:54 PM
Need Combobox and Date info mr_shoaib VB.NET 2002/2003 Basics 0 October 25th, 2005 05:49 AM
Query by date dsealer Access 11 November 9th, 2004 09:47 PM
Date based query when date is nvarchar MichaelTJ SQL Language 4 January 12th, 2004 09:57 PM
Convert String Date to Date for a SQL Query tdaustin Classic ASP Basics 4 July 7th, 2003 06:01 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.