# How to create a table with unique dates?

**URL:** <https://community.glideapps.com/t/how-to-create-a-table-with-unique-dates/75569>\
**Category:** Ask for Help\
**Created:** [August 10, 2024, 4:39am UTC](https://community.glideapps.com/t/how-to-create-a-table-with-unique-dates/75569 "2024-08-10T04:39:44Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 10, 2024, 1:24pm UTC](https://community.glideapps.com/t/how-to-create-a-table-with-unique-dates/75569/4 "2024-08-10T13:24:38Z")

</div>

Okay, cool.

So just focussing on your primary question, which is to create a list of unique dates, you can do it as follows:

- I’m assuming that your Logs table contains the email address of the user that added each row
- Start by creating a table, and add enough rows as you are likely to need (one row for each unique date)
- Add a Row Index by following the 2nd method described [here](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572).
- Add a Query column, target it at your Logs table, filter it where User Email is User Profile-\>Email, and order it by Date descending
- Create a Lookup column, target it at the Query column, and select the Date from the Logs table. This should give you an array of all dates for the signed in user.
- Add a [Unique Elements](https://www.glideapps.com/plugins/uniq) column and target it at the Lookup column. This will give you an array of unique dates.
- Add a Single Value column, target it at the Unique Elements column, and select `N` from start, where `N` is the Row Index.

This should give you a list of unique dates for the signed in user, with one date per row.

---

_[View the full topic](https://community.glideapps.com/t/how-to-create-a-table-with-unique-dates/75569)._