ssrs date question (1 Viewer)

[ielamrani]

Hi,

I have an ssrs report with 2 parameters.

start date with expression: =DateAdd("d",-1,Today())
and end date with expression: = today()

it works but query return date after midnight. I want End date to return yesterday's date up to 11:59PM only

Thank you.

 

[CJ_London]

if this is ssrs then you the dateadd function is slightly different to vba. Try

DateAdd(DateInterval.Day, -1, Today)

 

[ielamrani]

Thanks for your quick reply.

I tried it and got no data returned

 

[ielamrani]

Problem solved. I used the following in the query where clause:

(DATEDIFF(d, @startdate, a.delivery_datetime) >= 0) AND (DATEDIFF(d, @enddate, a.delivery_datetime) <= 0)

 

[ielamrani]

CJ,

yours worked also. I did not apply it to both parameters.

thank you.

 

[CJ_London]

good to know