Hello Team - How do I replace the below parameter with the logic?
below is the current logic
where [value_timestamp] >= dateadd(dd,-1, service_date)
I want to replace the where clause for valuetimestamp like below :
where [value_timestamp] between dateadd(hh,-24, service_date) and service_date
Does this work ?
where [value_timestamp] between dateadd(hh,-24, ?) and ? -- But do i need to create another parameter for this ( parameter 2 for teh SERVICE_DATE ?
Thank you

