Date formats in webpages

[Geoff Wickens]

I am new to using ASP and am trying to develop a site for the band I am a
member of. The data for our bookings is held in an Access database and I can
manipulate the date format as much as I like in Access but it doesn't make
any difference to what appears in my webpage.

The page is http://www.bedfordtownband.org.uk/calendar.asp

I want to get dates appearing as for example:

Sun 10 Aug 2003.

This is easy to achieve in Access and I have done so. However, I don't seem
to have any control over how the date appears in the asp page. To get the
day appearing which is important to me I have had to enter this as a field
in its own right, not really what I want to do. The code I use to produce
the calendar part of the page is as below:

<table width="100%" border="2" cellpadding="5">
<tr>
<td width="19%"><font size="1"><b>Date</b></font></td>
<td width="16%"><font size="1"><b>Band</b></font></td>
<td width="19%"><font size="1"><b>Venue</b></font></td>
<td width="16%"><font size="1"><b>Time</b></font></td>
<td width="30%"><font size="1"><b>Notes</b></font></td>
</tr>
<%
Set Catalog=Server.CreateObject("ADODB.Recordset")
Catalog.open "SELECT * FROM qrybookings", "DSN=calendar"
Do WHILE NOT Catalog.EOF
Response.Write "<tr valign='top'><td><font size='1'>" & Catalog("day") & " "
& Catalog("date") & "</font></td><td><font size='1'>" & Catalog("band") &
"</font></td><td><font size='1'>" & Catalog("venue") &
"</font></td><td><font size='1'>" & Catalog("time") & "</font></td><td><font
size='1'>" & Catalog("notes") & "</font></td></tr>"

Catalog.MoveNext
Loop
%>
</table>

I imagine there must be a way of doing this in ASP but I can't find it! If
anyone can help with this I would be very grateful indeed.

Geoff Wickens
Bedford Town Band

 

[Alan]

You have to format the date after you retrieve it. Look up the functions
WeekdayName() and FormatDateTime() in MSDN.

Regards,

Alan

 

[Alan]

Here is a link to the MSDN library online:
http://msdn.microsoft.com/library/default.asp

Alan

 

[Geoff Wickens]

Many thanks for the great assistance. I have now got it working!

Geoff