[thelist] ASP Date Data Type

[Chris Blessing]

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 !