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...

Can anyone get this to work with date parameters? I get a lovely error...

Msg 6522, Level 16, State 1, Procedure prc_ExportToExcel, Line 0

A .NET Framework error occurred during execution...