---
title: "Show the users who are celebrating their birthday today"
canonical: "https://support.appfire.com/space/REPS/475512147/Show%20the%20users%20who%20are%20celebrating%20their%20birthday%20today"
format: markdown
---
> Macro (aura-html)

## Scenario

Using the Report On macro combined with Scaffolding, you are able to extract a set of dates from a Scaffolding table.

This recipe shows you how to display users who are having their birthday today.

## Result

![image](media://21aaecd3-4ebd-4e28-ac8f-a43fda8dd360)

## Recipe

| Apps | Reporting for Confluence Data Center, Scaffolding Forms & Templates for Confluence Data Center |
| --- | --- |
| Level | Easy |
| Estimated time | 15 Minutes |
| Macros | Number Filter, Report On, Report Variable |
| Suppliers | Date Supplier, Scaffolding Data Supplier, Variable Supplier |

## Storage format

You can copy and paste this code into the [Confluence Source Editor](https://appfire.atlassian.net/wiki/spaces/REPS/pages/472907841):

```
<p>
  <strong>List of Birthdays</strong>
</p>
<ac:structured-macro ac:macro-id="22439cf5-f14c-4da4-ad06-74d7c6bccc94" ac:name="table-data" ac:schema-version="1">
  <ac:parameter ac:name="">birthdayList</ac:parameter>
  <ac:rich-text-body>
    <p class="auto-cursor-target">
      <br />
    </p>
    <table>
      <tbody>
        <tr>
          <th>
            <p>Name</p>
          </th>
          <th>
            <p>Birthdate</p>
          </th>
        </tr>
        <tr>
          <td>
            <p class="auto-cursor-target">
              <br />
            </p>
            <ac:structured-macro ac:macro-id="5cf48023-6c8f-45c7-a822-03bebfd7dba9" ac:name="text-data" ac:schema-version="1">
              <ac:parameter ac:name="type">line</ac:parameter>
              <ac:parameter ac:name="content">text</ac:parameter>
              <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
              <ac:parameter ac:name="">name</ac:parameter>
              <ac:rich-text-body>
                <p>
                  <br />
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
          </td>
          <td>
            <p class="auto-cursor-target">
              <br />
            </p>
            <ac:structured-macro ac:macro-id="4aa57614-bd07-465a-b9f7-b57ebb47b766" ac:name="date-data" ac:schema-version="1">
              <ac:parameter ac:name="format">dd-MMM-yyyy</ac:parameter>
              <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
              <ac:parameter ac:name="">birthDate</ac:parameter>
            </ac:structured-macro>
            <p class="auto-cursor-target">
              <br />
            </p>
          </td>
        </tr>
      </tbody>
    </table>
    <p class="auto-cursor-target">
      <br />
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p>
  <strong>Who's Celebrating Today?</strong>
</p>
<ac:structured-macro ac:macro-id="8012bf5a-8a86-4298-aa27-1baf31e95ce5" ac:name="report-on" ac:schema-version="1">
  <ac:parameter ac:name="injected">true</ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
  <ac:rich-text-body>
    <p class="auto-cursor-target">
      <br />
    </p>
    <ac:structured-macro ac:macro-id="324c9b60-b71c-4a36-be0b-368f8accdc48" ac:name="report-block" ac:schema-version="1">
      <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
      <ac:rich-text-body>
        <p class="auto-cursor-target">
          <br />
        </p>
        <ac:structured-macro ac:macro-id="42600bb7-8902-4483-87cb-58f442eff515" ac:name="local-reporter" ac:schema-version="1">
          <ac:parameter ac:name="">data:birthdayList</ac:parameter>
          <ac:rich-text-body>
            <ac:structured-macro ac:macro-id="2683a76a-d0db-4fa3-8f06-4dd705b216ac" ac:name="number-filter" ac:schema-version="1">
              <ac:parameter ac:name="minValue">%global:current date &gt; date:MMdd &gt; text:as number%</ac:parameter>
              <ac:parameter ac:name="maxValue">%global:current date &gt; date:MMdd &gt; text:as number%</ac:parameter>
              <ac:parameter ac:name="">data:birthDate &gt; date:MMdd &gt; text:as number</ac:parameter>
            </ac:structured-macro>
          </ac:rich-text-body>
        </ac:structured-macro>
        <p class="auto-cursor-target">
          <br />
        </p>
        <ac:structured-macro ac:macro-id="5a3850df-9eec-4dd8-94bb-b1a9144717ac" ac:name="report-body" ac:schema-version="1">
          <ac:rich-text-body>
            <p>
              <ac:structured-macro ac:macro-id="36a532a5-58a4-46f5-b9c6-d690a87a5ce0" ac:name="report-info" ac:schema-version="1">
                <ac:parameter ac:name="separator">comma</ac:parameter>
                <ac:parameter ac:name="">data:name</ac:parameter>
              </ac:structured-macro>
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <p class="auto-cursor-target">
          <br />
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p class="auto-cursor-target">
      <br />
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
  <br />
</p>
```

## Macro structure

You can recreate the example in the editor view:

![image](media://2052389b-8430-4efb-8905-7038491aa466)