CREATE TABLE YourTableName ( Subscriber INT PRIMARY KEY, IssueDate DATETIME, ExpireDate AS DATEADD(DAY, 30, IssueDate) )