Click to See Complete Forum and Search --> : DateTime Parameter CR 8.5


moleary77
November 13th, 2008, 03:42 PM
I have a parameter that the field is defined as datetime but I need it to display in my report parameters as just a date. I'm using a stored procedure and this does not allow me to edit the type of parameter that it is?

Ned Pepper
November 14th, 2008, 12:04 PM
If this is only a format issue, you can drop the parameter onto your report and format it to only display the date portion of the datatime value by using the format field options.

If you need to actually use the date portion then create a formula that returns only the date value using the DATEVALUE() funciton

DATEVALUE({MyDateTimeParameter})