I'm displaying records and using a field called ratedOn which is a datetime attribute with a getdate() default value. To display records on a page, say i wanted to only show records that are about 7 days old and anything older than 7 days, it won't display. How could i use a calculation in my query...
So for this example below only show records from May31st till today:
ratedon: 2007-06-06 12:00:10.020
I'd appreciate any help.
So for this example below only show records from May31st till today:
ratedon: 2007-06-06 12:00:10.020
I'd appreciate any help.