hi, to work with the date you could try something like this :substring(CAST(getdate() AS VARCHAR(20)),1,10)the inner varchar needs a number but ignores it, so the substring works also need string commands so use the concat:the one below should work:select concat('HEADER ',substring(CAST(getdate() AS...