I'm not really sure what your requirement is. You will need to use some form of dynamic sql.

declare @ColumnName varchar(50)

declare @sql nvarchar(max)

set @ColumnName = 'SalesData_' + convert(varchar(2),datepart(dd,getdate()))

set @sql = 'select ' + @ColumnName + ' from SalesTable'

print @sql

EXEC sp_sqlexec @sql