RSS RFC-822 Date format

I don't recall but trust your saying you've determined JET does not provide
native support for the RFC-822 format which you correctly surmise is the
only format proven to be supported by the majority of aggregators. Your
current date is non-compliant.

The best solution is to upsize to SQL Server which provides native support
for RFC-822. Meanwhile, you do not need an RFC-822 compliant data type per
se so use a text data type and build compliance using your server-side code.

You also want to know about the Advisory Board website [1]

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/

[1] http://www.rssboard.org/rss-specification


"Bob" <no@mail.com> wrote in message
news:f588ej$3i3$1@forums.macromedia.com...
> I've set up an rss feed using the example on
> http://www.geekpedia.com/tutorial157_Create-an-RSS-feed-using-ASP.NET-2.0.html
>
> However I use MS Access db and I would like to have the right date format
> which I belive is RFC-822.
>
> I'm in Europe and currently my date output looks like this
> <pubDate>18-06-2007 20:51:19</pubDate>
>
> <asp:AccessDataSource ID="AccessDataSource1" runat="server"
> DataFile="d:\web\database\news.mdb"
> DataSourceMode="DataReader" SelectCommand="SELECT storyDate,
> Title,
> Short, ArticleID FROM news ORDER BY storyDate DESC">
> </asp:AccessDataSource>
>
> Can anyone help me out with how I go by doing this?
>
> Thanks
> Bob
>
>
>
>