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