Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR XI - change date formart on Report Viewer

Status
Not open for further replies.

ReportDr00

IS-IT--Management
Mar 2, 2007
194
US

Hello

We have reports that are published on enterprise and accessed via web application and reports prompts for parameters and the format of date is 2009-01-01 (yyyy-mm-dd) and we would like to change the format to mm-dd-yyyy.

Can anyone know how it can be accomplished.
If you preview the reprot from enterprise it shows in yyyy-mm-dd, how can we change it to mm-dd-yyyy

Armani
 
You probably need to actually edit the report itself. I suspect that the parameter is actually in a string format which may or may not be converted when it's uses or that the default date field format in the report is set to yyyy-mm-dd.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
the parameter type is date and when you run the report it will prompot you to enter the date for the parameter in the default format of yyyy-mm-dd, is there a way we can change this default format to mm-dd-yyyy?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top