I have created a TableAdapter in the designer, and I have named parameters in the query. But the Fill and GetData methods that are generated are using the wrong datatype for one of my parameters. The query is in this form:

select * from invoice where (@InvoiceDate IS NULL OR (DateAdd(d, -14, @InvoiceDate) < invoice.InvoiceDate AND DateAdd(d, 14, @InvoiceDate) > invoice.InvoiceDate))

The generated methods see @InvoiceDate as an int, not a DateTime.

Is there a way for me to force it to recognize this parameter as a DateTime?