Is there a way to set NULL as default value in parameter for datetime column
I have three columns @id, @Sdate,@Edate .
In design i have choose the data type i have chosen @id as integer, @Sdate as date/time,@Edate as date/time
empty codes '' are not enabled for date/time data type.
for my requirement i need to pass as empty codes as @Sdate,@Edate
1. Is there a way to set NULL as default for datetime column parameter? in report builder it is enabling but when published default null check box is not checked, it is unchecked.
2. pass empty value in parameter for datetime column
PS: please dont ask for business logic behind this, i have more than columns as parameter, to ask i have said as 3 columns.