sql server reporting services: We have a couple of dates displayed on our report.
The first comes from a string in our code, and I have a format
of 'mm/dd/yyyy'

The second comes from Globals!ExecutionTime, and I have a format of 'd'

These both display the way we want (which is with leading zeros) when
we stream the report to Excel.

But when we use the ReportViewer control, or when we stream the report
to html, we get strange stuff, like

00/03/2005 (s/b 09/03/2005) in the first case,
and

42/20/2005 (s/b 02/20/2006) in the second case. (Particularly
perturbing, since this is an RS global)

Does using a capital m work properly? The lowercase m is for minute.
Check to see if "MM/dd/yyyy" works properly. I haven't had a problem
with the formatting and would be inetersted if this solved your
problem.


Regards,

Dan

Ahh..much better, thanks!