# Badge based on when user was promoted to moderator first time?

**URL:** <https://meta.discourse.org/t/badge-based-on-when-user-was-promoted-to-moderator-first-time/303035>\
**Category:** Data & reporting\
**Tags:** sql-triggered-badge\
**Created:** [April 9, 2024, 1:24pm UTC](https://meta.discourse.org/t/badge-based-on-when-user-was-promoted-to-moderator-first-time/303035 "2024-04-09T13:24:34Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![jrgong](https://avatars.discourse-cdn.com/v4/letter/j/c57346/32.png) [@jrgong](https://meta.discourse.org/u/jrgong)\
**Post date:** [April 9, 2024, 1:24pm UTC](https://meta.discourse.org/t/badge-based-on-when-user-was-promoted-to-moderator-first-time/303035/1 "2024-04-09T13:24:34Z")

</div>

Hey guys! I tried search, but could not find anything.

Is there any way to assign a badge based on how long a user has been a moderator?

In our case, we have mods who have been an essential part of the team for many years and we want to give them a special badge.

Basically the query should check conditions:  
Is user currently a mod?  
How many days has user held a moderator role?

That way we want to give out badges for modes who have been active 1y, 3y, 5y etc

---

_[View the full topic](https://meta.discourse.org/t/badge-based-on-when-user-was-promoted-to-moderator-first-time/303035)._