Query Run
SELECT (Format(DateAdd(MONTH,-6, GETDATE()), 'yyyyMMddHHmmSS')) 1 year ago