Query Run
SELECT (Format(DateAdd(MONTH,-6, GETDATE()), 'yyyyMMddHHmmSS')) 8 months ago