Hi, I have a date field in my database for my records and i want to disappear the records from my asp page if they are over a year old (365 days). How i can do this? The date field name is "trndate" and the date format in my database is like this "1/1/2011". Thank you in advance.
Hi, I don't know what database you are using, but if it is SQL Server then the query might be like this: select * from Table1 where trnDate>=getdate()-365; Hope I am right.