Posts: 6073 Reputation: 57
39 / /
Joined: Oct 2003
RE: database help
CREATE OR REPLACE VIEW MembershipDetails AS
SELECT LastUpdated, DateRegistered, datediff('d', getdate(), dateadd('yyyy', 1, LastUpdated)) as DaysLeftToRenew
FROM MemberList;
Should do the trick
This post was edited on 02-19-2006 at 10:47 PM by RaceProUK.
database help - by spokes on 02-15-2006 at 05:33 PM RE: database help - by Adeptus on 02-17-2006 at 02:42 PM RE: database help - by RaceProUK on 02-17-2006 at 02:57 PM RE: database help - by Adeptus on 02-17-2006 at 03:02 PM RE: database help - by RaceProUK on 02-19-2006 at 10:47 PM
/ 
![[Image: spartaafk.png]](http://www.rpsoftware.net/img/spartaafk.png)
