# Help me with Relation please

**URL:** <https://community.glideapps.com/t/help-me-with-relation-please/60615>\
**Category:** Ask for Help\
**Created:** [April 17, 2023, 1:19pm UTC](https://community.glideapps.com/t/help-me-with-relation-please/60615 "2023-04-17T13:19:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![atiwat\_tangchaiwatta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/atiwat_tangchaiwatta/32/22191_2.png) [@atiwat\_tangchaiwatta](https://community.glideapps.com/u/atiwat_tangchaiwatta)\
**Post date:** [April 17, 2023, 1:19pm UTC](https://community.glideapps.com/t/help-me-with-relation-please/60615/1 "2023-04-17T13:19:07Z")

</div>

![Screen Shot 2566-04-17 at 20.01.16](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/3/2364631363a69ab7e029f89aa93ec0de095f2b7e.jpeg)  
 ![Screen Shot 2566-04-17 at 20.05.33](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/a/3ab0035254d81fbb750eec87a74d29d1eb83b158.png)

 ![Screen Shot 2566-04-17 at 20.00.55](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8f8124da09d8e60708f9890609f35be79aabcca1.jpeg)  
 ![Screen Shot 2566-04-17 at 20.06.38](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/2/6261fa4d5479436c57c19433fb6fb64d673bb783.jpeg)

Hi Community , I am working on auto wage calculator  
I making Wage Calculator sheet which working well so far so I continue on individual employee count sheet . Idea is that the sheet will conclude those attendance each week which my main calculator sheet will look up those number of weekly attendance and calculate with formula

1. I build relation from Calculator sheet Date ( I pay my employee every Saturday) with End Date column of my employee sheet ( Pic1-2)
2. I build Lookup column (Pic3) to get those numbers of attendance
3. It didn’t work ( previously I working on get base salary from another sheet related by name , works well)

---

<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:** [April 18, 2023, 4:51am UTC](https://community.glideapps.com/t/help-me-with-relation-please/60615/2 "2023-04-18T04:51:14Z")

</div>

Most likely your relation isn’t working because the dates also contain a time component (which isn’t apparent in the editor). This is a common problem when building relations using dates.

Try this:

- For each of the two date columns that you want to match in the relation, create a Math column using the following formula:

```auto
Year(Date) * 10000
+ Month(Date) * 100
+ Day(Date)

```

- This will give you a number that looks like `20230418` (for todays date, for example)
- Use those two Math columns to create your relation.

---

<div class="post-metadata">

**Author:** ![atiwat\_tangchaiwatta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/atiwat_tangchaiwatta/32/22191_2.png) [@atiwat\_tangchaiwatta](https://community.glideapps.com/u/atiwat_tangchaiwatta)\
**Post date:** [April 22, 2023, 3:48am UTC](https://community.glideapps.com/t/help-me-with-relation-please/60615/3 "2023-04-22T03:48:02Z")

</div>

Really really thanks your kind help !!