Recent content by ielamrani

  1. I

    Group by date

    I got help and it's working now. Thank you for your help.
  2. I

    Group by date

    sorry about that. Yes it's 2 tables. caseintraop.pat_or_in_datetime, caseintraop.pat_or_out_datetime are used to calculate the total minute the patient was in OR (Operating Room)
  3. I

    Group by date

    Hi, I am close to making this work:confused: I have this table attending_res_name actcase_start_datetime minutes S_X 7/1/2017 8 S_X 7/1/2017 7...
  4. I

    SSRS date

    Issue resolved. I was missing one change in the query and now it's working. I put the following: startdate: =DateAdd(DateInterval.Second, +1, DateAdd(DateInterval.Day, 0, Today())) Result: 8/12/2016 12:00:01 AM Enddate: =cdate(format(now, "MMM dd, yyyy HH:mm:ss"))...
  5. I

    SSRS date

    thank you for your help anyway.
  6. I

    SSRS date

    this is in ssrs and yes now() gives today' date and current time. I put in startdate: =DateAdd(DateInterval.Second, +1, DateAdd(DateInterval.Day, 0, Today())) and I get 8/11/2016 12:00:01 AM under enddate: now() and I get : 8/11/2016 1:09:52 PM which is exactly what I want. but I am...
  7. I

    SSRS date

    this is what I did: under startdate exp I put: =DATEADD(day, 0, DATEDIFF(day, 0, GetDate())) under enddate exp I put: =now() dataset criteria: WHERE (b.hospital_name_location LIKE 'lh') AND (a.triage_arrival_time LIKE ?) AND (a.triage_arrival_time LIKE ?) i am still getting an error
  8. I

    SSRS date

    I tried it and I am getting this error: .....dd is not declared thank you.
  9. I

    SSRS date

    Hi, I created a report in ssrs with 2 parameters. Startdate and Enddate I want to default startdate to show today' date starting at Midnight and enddate to default to now. I am able to get Enddate to work but not Startdate thanks in advance.
  10. I

    ssrs date question

    CJ, yours worked also. I did not apply it to both parameters. thank you.
  11. I

    ssrs date question

    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)
  12. I

    ssrs date question

    Thanks for your quick reply. I tried it and got no data returned
  13. I

    ssrs date question

    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.
  14. I

    Mid question in SSRS

    Thank you.
  15. I

    Mid question in SSRS

    thank you for your quick response. I tried but did not work. I am new in ssrs.
Top Bottom