title: Changing the year of a date in SQL
body: <p>I am relatively new to programming. I have a table and in the table I have a column which shows when an employee started at the company. I am creating a procedure and within that procedure, I want to take the users start date and replace it with the current year, this will then be followed by an if statement. If the date that has just been calculated is before today, then change the year of the date to next year. Thanks and sorry if the question isn't fully clear or has been asked before.</p>