How do I change the value of a datetime parameter before submitting it to the query For instance, if the user selects '01/01/2006 00:00:00' in the date-picker, I want to submit '01/01/2006 23:59:59' to the query.
I tried
=Parameters!EndDate.Value.AddDays(1).AddSeconds(-1)

modify datetime parameter
Aparrel