redshift create date from parts, and each email you receive will include easy unsubscribe options.