# Display of database

**URL:** <https://community.glideapps.com/t/display-of-database/37951>\
**Category:** Ask for Help\
**Created:** [February 1, 2022, 3:52am UTC](https://community.glideapps.com/t/display-of-database/37951 "2022-02-01T03:52:44Z")\
**Posts on this page:** 4\
**Page:** 2

<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:** [February 1, 2022, 7:51am UTC](https://community.glideapps.com/t/display-of-database/37951/21 "2022-02-01T07:51:18Z")

</div>

So, just looking at it what you are trying to do is build a relation from your “Date” table to your “Слово дня” table, using the current date, yes?

Firstly, using the Format Date plugin to obtain the current date is problematic. That plugin is known to be buggy and unreliable. A better method is to just use a math column with the “Now” special value.

And then those extra columns you had with the split/splice/etc were never going to work reliably.

Given that you’re wanting to find records that fall within “Today”, all you really need to do is use an if-then-else column in your “Слово дня” table that returns “true” if the date is within today. And then use that if-then-else column to create the relation.

I’ve made the adjustments in your app. Take a look and let me know if you have questions.

> **[Copy of EnglishShow](https://bent-eggs-1911.glideapp.io/)**

Just as a side note, you have the app privacy set as “Public with Email”, but you don’t have [User Profiles](https://docs.glideapps.com/all/topics/security-and-user-data/user-profiles) configured. You should fix that, otherwise you’ll have more problems as you progress with the app.

---

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [February 1, 2022, 8:20am UTC](https://community.glideapps.com/t/display-of-database/37951/22 "2022-02-01T08:20:32Z")

</div>

Don’t forget to format Now if you want ti use it for a relationship with a date. Now contains time too!

---

<div class="post-metadata">

**Author:** ![kuzoraphd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kuzoraphd/32/38369_2.png) [@kuzoraphd](https://community.glideapps.com/u/kuzoraphd)\
**Post date:** [February 1, 2022, 8:41am UTC](https://community.glideapps.com/t/display-of-database/37951/23 "2022-02-01T08:41:33Z")

</div>

Thank you so much, Darren, for this detailed explanation and fixed my app!  
I have nothing to ask.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 2, 2022, 8:42am UTC](https://community.glideapps.com/t/display-of-database/37951/24 "2022-02-02T08:42:12Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.

[Previous page](https://community.glideapps.com/t/display-of-database/37951.md?page=1)