Forum Discussion
how to change a date format
Hi all
My report, shows a sum values for 01-01-2016, 01-02-2016, 01-03-2016 etc.
My question is: how can i change it to mmm-aaaa for example?
Tks a lot
Pedro
Are you wanting to change the way a date field shows in a Table visual in your report? If you select the field in the Fields pane on the right, then go to the Modeling tab in the ribbon at the top, you should see a Formatting section there. Click the drop-down for Format: and select any of the options under Date Time. Unfortunately, there is no option for a custom format, so hopefully there is something there you can use.
KGrice
Many thanks for your answer, although is not what i've expected.
Meanwhile i guess there's no other way than the way you've said. I thought, on a level report, you could do it.
Anyway, i've also found out that if you don't get the relations between tables right you also can have problems on the date field.
Tks anyway.
Best regards
Pedro
2 Replies
Are you wanting to change the way a date field shows in a Table visual in your report? If you select the field in the Fields pane on the right, then go to the Modeling tab in the ribbon at the top, you should see a Formatting section there. Click the drop-down for Format: and select any of the options under Date Time. Unfortunately, there is no option for a custom format, so hopefully there is something there you can use.
KGrice
Many thanks for your answer, although is not what i've expected.
Meanwhile i guess there's no other way than the way you've said. I thought, on a level report, you could do it.
Anyway, i've also found out that if you don't get the relations between tables right you also can have problems on the date field.
Tks anyway.
Best regards
Pedro