How can I get the date format from an SSRS report from the web service interface?

Question

I get report params in C# code from the webservice as follows:

ReportingService2005 ReportingService = ConnectToSSRS();
ReportParameter[] ReportParams = ReportingService.GetReportParameters(reportSelector.SelectedValue, HistoryID, ForRendering, emptyParams, null);

DateTime parameters currently seem to always come up as mm/dd/yyyy. Where is the date format defined? It's not hardcoded like this is it? Is there a way for me to obtain the DateFormat from code?

Thanks

Answer 1

What you're seeing is the default format string representation of the DateTime object (according to your locale...probably), so yes, in a sense, it is harcoded like that.

If you're working with a DateTime object though, rather than try and figure out what format it is in, you could just force it to whatever format you like best.

dt.ToString("MM/dd/yyyy hh:mm:sszzz")

You might want to take a look here for information that might help you. Also this.

Answer 2

Try to use ISO 8601 date format, e.g. 1999-06-01. It will work.