Rob- If I understand your question correctly, you say you want to _not_ show articles that have passed the expiration date (let's say it's the publish date + 7 days or something), right? In that case, you can check the current date and do a comparison between the publish date, something like: dim publishDate publishDate = cdate(<variable pulled from database or whatever>) if now() > dateAdd("d", 7, publishDate) then ' the article has expired else ' show the article end if Does that answer your question? Chris Blessing webguy at mail.rit.edu http://www.330i.net > -----Original Message----- > From: thelist-admin at lists.evolt.org > [mailto:thelist-admin at lists.evolt.org]On Behalf Of Rob Smith > Sent: Friday, April 05, 2002 12:04 PM > To: 'thelist at lists.evolt.org' > Subject: [thelist] ASP Date Data Type > > > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > -- > [ Picked text/plain from multipart/alternative ] > Hi thelist, > > I'm working on archiving user submitted news articles in a CMS. When users > log in, they see all articles they've submitted, whether or not they have > been edited and/or published. I want to avoid a large number of articles > being displayed when they login. > > Let's say a few articles have been published and are out of the review > cycle. There really isn't a need for the articles to be displayed > anymore. I > want to add an expiration date to each article published and need a way to > check if the article is ripe for removal from the users homepage. > > What ASP Date Data Types and procedures do you recommend to handle this? > > Rob > > (There isn't a need for session variables or cookies here, just strictly > code) > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt !