modify datetime parameter

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)



Answer this question

modify datetime parameter

  • Aparrel

    that is correct expression

  • modify datetime parameter