Date formats in webpages

Geoff Wickens · 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 [url]http://www.bedfordtownband.org.uk/calendar.asp[/url]

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%">Date</td>
<td width="16%">Band</td>
<td width="19%">Venue</td>
<td width="16%">Time</td>
<td width="30%">Notes</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>" & Catalog("day") & " "
& Catalog("date") & "</td><td>" & Catalog("band") &
"</td><td>" & Catalog("venue") &
"</td><td>" & Catalog("time") & "</td><td>" & Catalog("notes") & "</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 · Alan

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...

> 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 [url]http://www.bedfordtownband.org.uk/calendar.asp[/url]
>
> 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%">Date</td>
> <td width="16%">Band</td>
> <td width="19%">Venue</td>
> <td width="16%">Time</td>
> <td width="30%">Notes</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>" & Catalog("day") & "

"

> & Catalog("date") & "</td><td>" & Catalog("band") &
> "</td><td>" & Catalog("venue") &
> "</td><td>" & Catalog("time") &

"</td><td><font

> size='1'>" & Catalog("notes") & "</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 · Alan

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

Alan

"Alan" <SPAMMENOTalan.howard@inspire.net.nz> wrote in message
news:OtGosryXDHA.2448@TK2MSFTNGP09.phx.gbl...

> 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...

> > 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 [url]http://www.bedfordtownband.org.uk/calendar.asp[/url]
> >
> > 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%">Date</td>
> > <td width="16%">Band</td>
> > <td width="19%">Venue</td>
> > <td width="16%">Time</td>
> > <td width="30%">Notes</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>" & Catalog("day") &

"

> "

> > & Catalog("date") & "</td><td>" & Catalog("band")

&

> > "</td><td>" & Catalog("venue") &
> > "</td><td>" & Catalog("time") &

> "</td><td><font

> > size='1'>" & Catalog("notes") & "</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
> >
> >

>
>

Geoff Wickens · Geoff Wickens

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...

> Here is a link to the MSDN library online:
> [url]http://msdn.microsoft.com/library/default.asp[/url]
>
> Alan
>
>
> "Alan" <SPAMMENOTalan.howard@inspire.net.nz> wrote in message
> news:OtGosryXDHA.2448@TK2MSFTNGP09.phx.gbl...

> > 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...

> > > 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 [url]http://www.bedfordtownband.org.uk/calendar.asp[/url]
> > >
> > > 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%">Date</td>
> > > <td width="16%">Band</td>
> > > <td width="19%">Venue</td>
> > > <td width="16%">Time</td>
> > > <td width="30%">Notes</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>" & Catalog("day")

&

> "

> > "

> > > & Catalog("date") & "</td><td>" &

Catalog("band")

> &

> > > "</td><td>" & Catalog("venue") &
> > > "</td><td>" & Catalog("time") &

> > "</td><td><font

> > > size='1'>" & Catalog("notes") & "</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
> > >
> > >

> >
> >

>
>

Date formats in webpages

Thread Tools

Display

Date formats in webpages

Similar Questions and Discussions

Dreamlettes Calendar Extension - Date Formats

date formats

SQL Server & international date formats

Handle multiple input date formats?

Converting Date Formats?

Re: Date formats in webpages

Re: Date formats in webpages

Re: Date formats in webpages

Posting Permissions