SSRS Date Formating

=Format(Fields!DateCreated.Value, “M/d/yy”) – 3/14/1986
=Format(Fields!DateCreated.Value, “d-MMMM-yy”) – 14-March-86
=Format(Fields!DateCreated.Value, “MM/dd/yyyy”) – 03/14/1986
=Format(Fields!DateCreated.Value, “M/d/yyyy H:mm”) – 3/14/1986 22:10
=Format(Fields!DateCreated.Value, “dd-MMM-yyyy”) – 14-March-1986
=Format(Fields!DateCreated.Value, “MMM-dd-yyyy”) – Mar-14-1986
=Format(Fields!DateCreated.Value,“dd-MMM-yy”) – 14-Mar-86

Date formatting

Advertisements
By simplemsexchange Posted in SSRS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s