Date format

I want to show the date in mm/dd/yy date format. In the formatdatetime function I can only specify the long date / Short date. If I am specifying short date it is taking from the system regional settings [In the regional settings it is specified as mm/dd/yyyy]. I want to show mm/dd/yy only to this report and mm/dd/yyyy to other reports. Can you please let me know how to do this?

Thanks

Where? Can you post some code?

|||

I am using the following code to show the date in my SQL Server reportig services report,

FormatDateTime(Fields!Date.Value,2). It is showing mm/dd/yyyy format. I want to show in mm/dd/yy format. This mm/dd/yy format is only for one report. I want to show mm/dd/yyyy for the other reports.

|||

See if this helps:

=Format(Fields!Date.Value,"MM/dd/yy") ' this is case sensitive

Got it from your other post:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2372543&SiteID=1

|||

I got the answer. I have to use the following,

Format(Fields!YourDateField.Value,"MM/dd/yy")

|||

Thank you. This is working