# Relation issue **URL:** \ **Category:** Ask for Help\ **Created:** [November 25, 2022, 1:43am UTC](https://community.glideapps.com/t/relation-issue/54890 "2022-11-25T01:43:12Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [November 25, 2022, 1:43am UTC](https://community.glideapps.com/t/relation-issue/54890/1 "2022-11-25T01:43:12Z")
Basically i have two sheets . Gazette Holiday and TimesheetDAY where it should be related using the “Date” column. Image 1 : Showing the Gazzeted Holiday for 18 Nov 2022 (row 41) ![Glideapps](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/4/f42f15562e60d613cf5130ee3378596285e90bed.png) Image 2 : The TimesheetDAY sheet which have date 18 Nov 2022 Row 1440 ![Glideapps 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f292fb867308c24c433b52c3944c5a7b6af04657.png) Image 3 : Using Relation Column using “Date” column ![Glideapps 3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8bb4573b5c813a3010cf62e1ed9705060a218ae3.png) Image 4 : Using lookup. Nothing come out. ![Glideapps 4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2efa92aa53955a26836ef892862837561489464f.png) My question is how to solve ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 25, 2022, 2:15am UTC](https://community.glideapps.com/t/relation-issue/54890/2 "2022-11-25T02:15:51Z")
are you sure these are the exact dates? Remember dates have time… with seconds and milliseconds… to match just a date, you need to convert it to text ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [November 25, 2022, 2:19am UTC](https://community.glideapps.com/t/relation-issue/54890/3 "2022-11-25T02:19:05Z")
Like , i have created this apps for years ago. I noticed in the mid of July the format i added to the row have been changed ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/ead55288538c9b80dbd4e6d42fec93d9d8cfdc81.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 25, 2022, 2:22am UTC](https://community.glideapps.com/t/relation-issue/54890/4 "2022-11-25T02:22:14Z")
try to convert… and see if it helps… use the format date column… it works for me ![Screen Shot 2022-11-24 at 9.25.55 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/05b25ceb4a0e15114f39f12fc3b19e127e0b2d51.png) ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [November 25, 2022, 2:25am UTC](https://community.glideapps.com/t/relation-issue/54890/5 "2022-11-25T02:25:23Z")
but when the new row added, the format is not as above cell right. ---
**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:** [November 25, 2022, 3:11am UTC](https://community.glideapps.com/t/relation-issue/54890/6 "2022-11-25T03:11:40Z")
just beware, the Format Date plugin is known to give inconsistent results. It’s much safer to convert the dates to an integer using a math column: ```auto Year(Date) * 10000 + Month(Date) * 100 + Day(Date) ``` and then use that for your relation. ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [November 25, 2022, 8:26am UTC](https://community.glideapps.com/t/relation-issue/54890/7 "2022-11-25T08:26:02Z")
Hi @Darren_Murphy , I tried, but the answer is different with the original date eg: Original date is 5 Nov 2022 (Image 1) after using the math column and add row it become as Image 2. ![Capture 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/2622f0fca57dafda5c27db5e7029a550ae8977c8.png) Image 1 ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/43053353754b8e8c71fb0dec9333395ed5875772.png) Image 2 ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [November 25, 2022, 8:37am UTC](https://community.glideapps.com/t/relation-issue/54890/8 "2022-11-25T08:37:07Z")
Yes, you are right, date format column is not consistent, Eg: just now i created dd/MM/yyyy format. seems okay. after some time the result of added row was. MM/dd/yyyy ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 25, 2022, 8:38am UTC](https://community.glideapps.com/t/relation-issue/54890/9 "2022-11-25T08:38:56Z")
it is important lower or upper case … and positon… fallow my example ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [November 25, 2022, 8:41am UTC](https://community.glideapps.com/t/relation-issue/54890/10 "2022-11-25T08:41:14Z")
Yes, but at the added row sheet , date(“dd”) at the front ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 25, 2022, 8:41am UTC](https://community.glideapps.com/t/relation-issue/54890/11 "2022-11-25T08:41:59Z")
or simply do the text date… it will never break… make 3 math columns to separate day… month… year… then use template column to join… it will become solid text… nothing can break that ---
**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:** [November 25, 2022, 8:42am UTC](https://community.glideapps.com/t/relation-issue/54890/12 "2022-11-25T08:42:19Z")
> [@biha](#): > > Original date is 5 Nov 2022 (Image 1) after using the math column and add row it become as Image 2. I don’t really understand what you’ve done there. The math column should only be used for creating the relation, it should not be written back into the Google Sheet. Can you show me the configuration of your Math column? ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [November 25, 2022, 8:44am UTC](https://community.glideapps.com/t/relation-issue/54890/13 "2022-11-25T08:44:00Z")
![Capture 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/ddaaca57f437a65fb47168e7f67e3b92a309d29d.png) here you go ---
**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:** [November 25, 2022, 8:45am UTC](https://community.glideapps.com/t/relation-issue/54890/14 "2022-11-25T08:45:31Z")
Whoops, my bad. The formula I gave you was missing a zero… Try this: ```auto Year(Date) * 10000 + Month(Date) * 100 + Day(Date) ``` ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 25, 2022, 8:48am UTC](https://community.glideapps.com/t/relation-issue/54890/15 "2022-11-25T08:48:35Z")
i see we have defernt bases , how to approach data lol… main goal is to get off Glide marking records… is anoing and wrong ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [November 25, 2022, 8:49am UTC](https://community.glideapps.com/t/relation-issue/54890/16 "2022-11-25T08:49:58Z")
Our date format different ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 25, 2022, 8:52am UTC](https://community.glideapps.com/t/relation-issue/54890/17 "2022-11-25T08:52:44Z")
all over the world … time/date format is always hard to do… I would be happy if Glide follow GS ---
**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:** [November 25, 2022, 8:53am UTC](https://community.glideapps.com/t/relation-issue/54890/18 "2022-11-25T08:53:08Z")
@biha - I’m not sure if you’re understanding what I’ve suggested. That math formula that I gave you should be created in _both_ tables. Then you create a relation that matches the values in the two math columns. ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [November 25, 2022, 8:53am UTC](https://community.glideapps.com/t/relation-issue/54890/19 "2022-11-25T08:53:43Z")
oh! got it got it . Both. ---
**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:** [November 25, 2022, 8:55am UTC](https://community.glideapps.com/t/relation-issue/54890/20 "2022-11-25T08:55:45Z")
> [@Uzo](#): > > i see we have defernt bases , how to approach data lol… main goal is to get off Glide marking records… is anoing and wrong Well, in the context of this thread… - a) I don’t believe that GS formulas are needed, so they are best avoided, and - b) I don’t trust the Format Date plugin, so that is also best avoided That leaves Glide Date Math, which does the job perfectly well 😉 [Next page](https://community.glideapps.com/t/relation-issue/54890.md?page=2)