SSRS datetime parameter problem

• gururajan

  SSCrazy

  Points: 2875

  More actions

  July 23, 2009 at 3:46 am

  #385038

  Hi

  I Using Datetime parameters for check the querystring in SSRS 2005

  Parameters are: rpFromDate and rpToDate

  i am using following way

  SELECT BILL_NO,BILL_DATE,BILL_AMOUNT FROM BILL_PROCESS

  WHERE BILL_DATE BETWEEN '2009-07-01' AND '2009-07-23'

  PARAMETERS ARE

  SELECT BILL_NO,BILL_DATE,BILL_AMOUNT FROM BILL_PROCESS

  WHERE BILL_DATE BETWEEN @rpFromDate AND @rpToDate

  I am getting error if any way to avoid error to get result?

  I am only want to use datetime parameter.

  but i am used string for the date parameter getting answer is correct.

  urjent pls

  Gururajan.K

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  July 28, 2009 at 11:22 am

  #1031200

  Can you post the actual error you are seeing? That would be rather helpful in answering your question.

  One thing to note, since you're using between and note passing the time portion of the datetime, be aware you may be missing data.

  between '2009-01-01' and '2009-01-31' misses anything that occurred after midnight (00:00:00.001) on Jan 31.

  To help us help you read this[/url]For better help with performance problems please read this[/url]

• javedteri 87594

  Newbie

  Points: 3

  More actions

  August 8, 2011 at 12:36 am

  #1365030

  i m not getting ur point

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  August 8, 2011 at 12:51 am

  #1365035

  The point being

  1) Post the exact error message you see

  2) 31/1/2011 = 31/1/2011 00:00:00.000 and not 31/1/2011 23:59:59.999

  Have you considered point 2 in your logic ?

  Jayanth Kurup[/url]