Many thanks for the great assistance. I have now got it working!
Geoff
"Alan" <SPAMMENOTalan.howard@inspire.net.nz> wrote in message
news:unx65syXDHA.2620@TK2MSFTNGP09.phx.gbl...[color=blue]
> Here is a link to the MSDN library online:
>
http://msdn.microsoft.com/library/default.asp
>
> Alan
>
>
> "Alan" <SPAMMENOTalan.howard@inspire.net.nz> wrote in message
> news:OtGosryXDHA.2448@TK2MSFTNGP09.phx.gbl...[color=green]
> > You have to format the date after you retrieve it. Look up the functions
> > WeekdayName() and FormatDateTime() in MSDN.
> >
> > Regards,
> >
> > Alan
> >
> > "Geoff Wickens" <gwickens@ntlworld.com> wrote in message
> > news:Q2pZa.114$Ll.67372@newsfep1-win.server.ntli.net...[color=darkred]
> > > I am new to using ASP and am trying to develop a site for the band I[/color][/color][/color]
am[color=blue]
> a[color=green][color=darkred]
> > > member of. The data for our bookings is held in an Access database and[/color][/color][/color]
I[color=blue][color=green]
> > can[color=darkred]
> > > manipulate the date format as much as I like in Access but it doesn't[/color][/color]
> make[color=green][color=darkred]
> > > 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[/color]
> > seem[color=darkred]
> > > to have any control over how the date appears in the asp page. To get[/color][/color]
> the[color=green][color=darkred]
> > > day appearing which is important to me I have had to enter this as a[/color][/color]
> field[color=green][color=darkred]
> > > in its own right, not really what I want to do. The code I use to[/color][/color]
> produce[color=green][color=darkred]
> > > 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")[/color][/color][/color]
&[color=blue]
> "[color=green]
> > "[color=darkred]
> > > & Catalog("date") & "</font></td><td><font size='1'>" &[/color][/color][/color]
Catalog("band")[color=blue]
> &[color=green][color=darkred]
> > > "</font></td><td><font size='1'>" & Catalog("venue") &
> > > "</font></td><td><font size='1'>" & Catalog("time") &[/color]
> > "</font></td><td><font[color=darkred]
> > > 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[/color][/color][/color]
it![color=blue][color=green]
> > If[color=darkred]
> > > anyone can help with this I would be very grateful indeed.
> > >
> > > Geoff Wickens
> > > Bedford Town Band
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]
Date formats in webpages 
