Hi every one
any one tell me that if i post an article on my website and i want that the article don't disply after one month? In my table there is a field of date which save the date of the artcile when it is posted and one field of table is isExpire. The isExpire show 0 after one month other wise it will show 1. Now tell me how i can make this function that check that the posted article how much old???

waiting for your reply
Thanks in advance

You can use DATEDIFF in your query. That would eliminate the need for the isExpired column.