|
Subject:
|
extra date info from query
|
|
Posted By:
|
abbylee26
|
Post Date:
|
12/3/2003 9:37:10 AM
|
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
|
|
Reply By:
|
pgtips
|
Reply Date:
|
12/4/2003 8:45:46 AM
|
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.
|
