# Display record based on current date

**URL:** https://community.glideapps.com/t/display-record-based-on-current-date/3023
**Category:** Ask for Help
**Created:** [December 20, 2019, 6:51am UTC](https://community.glideapps.com/t/display-record-based-on-current-date/3023 "2019-12-20T06:51:57Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![amurtuza](https://avatars.discourse-cdn.com/v4/letter/a/2acd7d/32.png) [@amurtuza](https://community.glideapps.com/u/amurtuza)
#### Post date: [December 20, 2019, 6:51am UTC](https://community.glideapps.com/t/display-record-based-on-current-date/3023/1 "2019-12-20T06:51:57Z")

</div>

Hi, I need some help:

I have date field in the spreadsheet. I want to display the records based on current date.

First, I want to know the correct data format in the spreadsheet. Currently I am formatting yyy-mm-dd. Is this okay?

Second, i want to display the record (of spreadsheet) where date field equals to current date. There ia a filter available on the Date field, but I want to know the command for Current Date.

 ![15768245028815955251735466681419](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/604ab2f64b2902999f09bf81ee32dee627edda91.jpeg)

Help is appreviated  
Thanks

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 20, 2019, 2:46pm UTC](https://community.glideapps.com/t/display-record-based-on-current-date/3023/2 "2019-12-20T14:46:35Z")

</div>

Try changing the format of the column in Google sheets to a date. This might help glide to recognize it as a date column. Then you should get the option to use the filter to compare the date column to Today or Now.

---

<div class="post-metadata">

### Author: ![amurtuza](https://avatars.discourse-cdn.com/v4/letter/a/2acd7d/32.png) [@amurtuza](https://community.glideapps.com/u/amurtuza)
#### Post date: [December 22, 2019, 5:32pm UTC](https://community.glideapps.com/t/display-record-based-on-current-date/3023/3 "2019-12-22T17:32:52Z")

</div>

Hi Jeff thanks. I made the changes. I could not make it to work.I have selected the date field is Today, Now, Today(), Now() in Components/Features/Filter, but it always displays the first record.

Then I put the condition the filter in Google Spreadsheet to display data today. It works and shows only one record.

Even if I leave this condition the glideapps is picking up the first record and not reading the filter.

thanks  
Abbas

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 23, 2019, 2:46am UTC](https://community.glideapps.com/t/display-record-based-on-current-date/3023/4 "2019-12-23T02:46:12Z")

</div>

It’s hard to say without screenshots or a copy of the spreadsheet. Here’s a few things to check.

- Did you set the entire column to a date column, or just one cell in the sheet?
- Is your filter using Date 'Is Within" Today?
- Is every date in your sheet formatted properly? I only ask because in your first screenshot, you have a date with dashes, then the the rest of the dates do not have dashes.
- What exactly did you put in your sheet for a condition?
- Are you using a relation to get records? Is it a Single vs Multiple relation?