# Dashboard Report - Topics with No Response

**URL:** <https://meta.discourse.org/t/dashboard-report-topics-with-no-response/294002>\
**Category:** Data & reporting\
**Tags:** sql-query, dashboard-reports, dashboard-sql\
**Created:** [February 2, 2024, 10:55pm UTC](https://meta.discourse.org/t/dashboard-report-topics-with-no-response/294002 "2024-02-02T22:55:48Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![SStrong](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@SStrong](https://meta.discourse.org/u/SStrong)\
**Post date:** [September 4, 2024, 9:20am UTC](https://meta.discourse.org/t/dashboard-report-topics-with-no-response/294002/7 "2024-09-04T09:20:30Z")

</div>

Thanks, that’s resolved the how to get the year piece.

I’m now stuck again as dates in postgre seem to behave differently

to\_char(t.created\_at, ‘MM-YY’) as Yearmonth,

This is giving me 10-22 which represents “Oct-22”

How am I able to change 10-22 to Oct-22? I have tried to look at guidance within discourse but not been able to find this, unless I’m not sure where to look?

Thanks

---

_[View the full topic](https://meta.discourse.org/t/dashboard-report-topics-with-no-response/294002)._