Extend Membership Expiration date base on current expiration date
Search
Extend Membership Expiration date base on current expiration date
This script will add time to the existing expiration date based on the expiration date. It will also add a note to the membership to record the change.
USE clubspeedv8
GO
ALTER TABLE dbo.Memberships
ALTER COLUMN NOTES NVARCHAR(MAX)
GO
update dbo.Memberships
set notes = dbo.Memberships.Notes + SPACE(1) + '- (Enter todays date) Extend expiration date 6 months per FD18160'
where ExpirationDate > '01-26-2021'
go
ALTER TABLE dbo.Memberships
ALTER COLUMN NOTES NTEXT
go
update dbo.Memberships
set lastChanged = CURRENT_TIMESTAMP
where ExpirationDate > '01-26-2021'
go
update dbo.Memberships
set ExpirationDate = DATEADD(MONTH,6,ExpirationDate)
where ExpirationDate > '01-26-2021'
go