Macro using dates for SQL

ecdbert

Hi:
I'm trying to use a macro with date in an SQL statement but I'm getting an error from the SQL side. Here is part of the SQL statement: 

Declare @fDate date, @tdate date , @processingdate date, @lag int =%{lag}

SET @fDate =%{themonth}

error message is "Operand type clash: int is incompatible with date."

How do I resolve this?

ecdbert

UPDATE: I've resolved this by using 'concat' to add single quotes before and after the macro value in a 'Generate Macro' operator.