Help with Calculated Field date format MMM-yy

[shobdy (Shawn Hobdy)]

Hello,

I am getting some weird stuff happening, lol.

I created a BAQ that has a calculated field set as a date type.

I changed the format to MMM-yy and the BAQ returns it perfect like: Jan-24

The issue I am running into is when I try to create a dashboard with this field on it, it shows to results like: Jan-YY

What am I missing here?

[shobdy (Shawn Hobdy)]

Hello,

Does anyone else have this issue?

If so, I can report to support to see if they can resolve it.

Any help is appreciated.

[GThom (Gage Thompson)]

It looks like following Nate or Doug’s advice should fix your issue depending on if you have customization rights or not, respectively.

BAQ vs Dashboard date format issue

Good morning! Try this, [dateformat] Customize your dashboard, and click on your grid. In Properties there is a columns list. Click the drop down and find the field you want to change the format for. I hope this helps! Nate