You will need to use dynamic sql and the getDate() function.

This should get you started...

@TABLE_NAME VARCHAR(50),

@SQL VARCHAR(MAX),

Set @TABLE_NAME = CONVERT(VarChar(20), GETDATE(), 101)

/* Generate table */

SET @SQL = Add create table sql here.

/* Execute dynamic sql*/

EXEC(@SQL)