Hi,
There isn't an easy way to change the date format directly in Story Reports. However, SAP provides a KBA that explains how to manually convert the date format:
2986093 - How to manually change the Date Format for a date field in Story report - SAP for Me
I’d also like to share my formula for this, including how to return 0 if the month or day have one digits.
CONCAT(
TOTEXT(YEAR([FIELDNAME])),
CONCAT("-",
CONCAT(
RIGHT(CONCAT("0", TOTEXT(MONTH([FIELDNAME]))), 2),
CONCAT("-",
RIGHT(CONCAT("0", TOTEXT(DAY([FIELDNAME]))), 2)
)
)
)
)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.