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 |
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.
Examples:
4-JUL-2017
17-MAR-2017