You can change the date format on a report, it just depends on the type of component.
For a slicer
To format the date:
Select the component containing the date field.
Go into the Inspector window and select “Data Format”.
You can then choose a predefined format or create your own.
To create your own:
Scroll down to the Custom section and edit the format from the Type field.
For Table and Chart Components
Change the data field properties.
Select the component containing the date field.
Select the Exact Date.
Change the data field properties in Data Binding.
In Data Binding click on the cog and Edit the Format…
Alternatively, you can also:
Edit format.
Scroll down to Custom.
In Custom choose how the date is displayed, edit Type: field
Change the date display
When adding Date fields (where available) from 1 per column i.e day - Month - Year to show in the same column as one entry.
Select the component containing the date field.
Then, select the Exact Date.
Examples of Date Formatting
Day | Month | Year |
dd = 13 | mm = 11 | yy = 23 |
ddd = Mon | mmm = Nov | yyyy = 2023 |
dddd = Monday | mmm = November |
|
Format | Output Result |
dd mm yy | 13 11 23 |
ddd/mmm/yyyy | Mon/Nov/2023 |
dddd-mmm | Monday-November |
PRO TIP: You can use any divider - Slash or dash ""/" "-" or none
e.g. dd-mm-yy - dd/mm/yyy - dd mm yy