You need to sign in to do that
Don't have an account?
Emily Song
Showing Month-Year on a report MMM-YY instead of numbers DD/MM/YYYY
Hi all!
I have been trying to do this for a while! I need to get my reports to show month and year in format MMM-YY e.g. Jun-18 and be in the correct order. I have tried putting it as text but it puts them in the order Jan-18, Jan-19, Feb-18, Feb-19 etc.
Any help would be great!
Thanks!
Emily
I have been trying to do this for a while! I need to get my reports to show month and year in format MMM-YY e.g. Jun-18 and be in the correct order. I have tried putting it as text but it puts them in the order Jan-18, Jan-19, Feb-18, Feb-19 etc.
Any help would be great!
Thanks!
Emily
You cannot format the date in the report. You have already created a new formula with a format MMM-YY but you need to have the two fields (date for the order and formula for the format on the report)
https://help.salesforce.com/articleView?id=000123532&type=1
The alternative is to use a summary report group by Calendar Month