Datetime Parameters

• Marv_SQL

  SSCommitted

  Points: 1612

  More actions

  June 8, 2010 at 11:41 am

  #225457

  I have a stored procedure that executes based off a @startdate and @enddate parameters.

  I run this procedure by running a crystal report. The problem that I am having with crystal reports is when I get prompted to enter in the parameters, the @startdate and @enddate is asking me for date and time.

  I just want the date to be the only thing that can get selected. How do i Convert the @startdate and @enddate datetime parameters to just a date?

  Thanks:cool:

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  June 8, 2010 at 12:26 pm

  #1177636

  Try putting in the date with a time of midnight for example

  2010-06-08 00:00:00.000

  and see if this gives you the results you require

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]