DECLARE @date date = '04-18-2020' --date for act; SELECT YEAR(date), MONTH(date) --, DAY(date) add if u want day