Search code examples
reporting-servicesreportingservices-2005

Format Last date not picking up specific formatting

I'm trying to get the most recent date from my AuthAmounts dataset in a MM/dd/yyyy format but it refuses to strip off the time value. I've tried every permutation I can think of, including the following:

=Format(Last(Fields!CustAuthorizationDate.Value,"MM/dd/yyyy"), "AuthAmounts")
=Last(Format(Fields!CustAuthorizationDate.Value,"MM/dd/yyyy"), "AuthAmounts")
=Format(Last(Fields!CustAuthorizationDate.Value,"AuthAmounts"), "MM/dd/yyyy")
=Last(Format(Fields!CustAuthorizationDate.Value,"AuthAmounts"), "MM/dd/yyyy")

In every case, I get back something like 10/26/2010 12:00:00 AM. What am I missing here?

Solution

  • As noted in the discussion above in SSRS 2005 (BIDS), the user must sometimes save, close, and reopen the solution for the code changes to actually work. As frustrating as this is, it is far LESS frustrating than having properly formatted expressions be repeatedly rejected by the system and not know why that is!