Adding a month to a date in T SQL July 28, 2023 by Tarik SELECT * FROM Reference WHERE reference_dt = DATEADD(MONTH, 1, another_date_reference)