I finally got it last night. What you have to do is a few converts on the datetime field. Here is a quick example...
--Exporting to Excel
DECLARE @cdate NVARCHAR(MAX)
SET @cdate = '2012-03-24T00:00:00' -- XML DATTIME
SET @params = '<params><param name="cdate" value="' + @cdate + '" /></params>'
exec prc_ExportToExcel 'Your Stor Proc', 'Your File Loc', 'Name', @params
--Stor Proc Examp
DECLARE @cdate DATETIME
WHERE (Table.Date <= CONVERT(DATETIME, @cdate, 126)) --126 lets SQL know that it is a XML DATETIME format, and converts it to SQL DATETIME format
Hope this helps someone who may need to do the same thing I was working on 🙂