# Pivot table with date fields

**URL:** https://community.noloco.io/t/pivot-table-with-date-fields/1943
**Category:** Bugs
**Created:** [May 28, 2025, 2:43pm UTC](https://community.noloco.io/t/pivot-table-with-date-fields/1943 "2025-05-28T14:43:05Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)
#### Post date: [May 28, 2025, 2:43pm UTC](https://community.noloco.io/t/pivot-table-with-date-fields/1943/1 "2025-05-28T14:43:06Z")

</div>

Hello, not entirely sure this is a bug or just the way its been created. I am trying to recreate the below query into a Noloco Pivot with a date field on both row & column.

**This is what mysql query I created outputs:**

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/6/68f449441fa1bf2fc64e230a12ca9cdad220ab55.png)

**This is what the Noloco Pivot outputs:**  
Row is grouped by year | Column grouped by month

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/8/8d88be0a2e6e6b67be6a14e5a7695a421b72ef1b.png)

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/7/72121a527dd795fb05fd710f45391af91805ff6d.png)