Out of the Box SSRS Report Date Issues solved for all - use dd-MMM-yyyy

In all SSRS reports out of the Box all Date fields should be formatted as:

=Format(Fields!MD_StartDate.Value,"dd-MMM-yyyy")

This means all countries everywhere in the world get date in same format instead of US getting dd/mm/yyyy and other countries

wanting mm/dd/yyyy and logging fixes.

  • Guest
  • Apr 4 2017
Organization Name (Please enter full organization name) Plan International Australia
Reported Version 4.0
  • Attach files
  • Guest commented
    April 04, 2017 05:09

    Examples:

    4-JUL-2017

    17-MAR-2017

  • David Bourne commented
    April 19, 2017 23:52

    Agree - having worked with international organisations before I have got into the habit of using a similar format, although I prefer dd-Mmm-YY.

     

    Examples:

    04-Jul-17

    12-Jan-18

     

    The short year gives you more room in the report design, and the leading zero aligns the dates better in a column.