# Date column is a lookup **URL:** \ **Category:** Ask for Help\ **Created:** [February 25, 2022, 6:03pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969 "2022-02-25T18:03:16Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [February 25, 2022, 6:03pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/1 "2022-02-25T18:03:16Z")
The date column is a look up and I need only the date from the values.how to get the date value only. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 25, 2022, 11:48pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/2 "2022-02-25T23:48:07Z")
You can add a math column, reference the lookup column and format the date to “Date only”. ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [February 26, 2022, 10:20am UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/3 "2022-02-26T10:20:47Z")
How to reference lookup column in math column. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 26, 2022, 12:29pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/4 "2022-02-26T12:29:09Z")
Just add a character, let’s say “D” and point the D character to the lookup column. ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [February 26, 2022, 12:42pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/5 "2022-02-26T12:42:18Z")
Any examples please.cound not understand. My question: I have a look up column which is a date column.but I need to display only the date. ---
**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 26, 2022, 12:59pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/6 "2022-02-26T12:59:16Z")
![Screen Shot 2022-02-26 at 8.58.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2d804a578d7eaaa2005ddf2571b4f86260b412ea.png) ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [February 26, 2022, 1:43pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/7 "2022-02-26T13:43:04Z")
Hi darren my problem is,i have 2 tables as snacklist and orders. i need the date from orders table to snacklist table.i get it by relation with orders table and get the date by lookup in snacklist.everything i got but its like this below,i couldn’t do anything,tried format and math column but not getting in date only format. ![doubtn](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/702fa160d32a5fadb43729caadc0f4694d7ec140.png) any other alternatives to get this? ---
**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 26, 2022, 1:45pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/8 "2022-02-26T13:45:04Z")
Please show me a screen shot of the configuration of the original date column from the orders table. I suspect that it is not properly configured as a datetime column type. ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [February 26, 2022, 1:47pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/9 "2022-02-26T13:47:01Z")
![doubtn1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b22c200ac064fea7036dbc6b991a24e1b71480e.png) ---
**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 26, 2022, 1:50pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/10 "2022-02-26T13:50:11Z")
Please double-click on the column header to edit it, and double check the column type. Make sure it is set as Date/Time. ![Screen Shot 2022-02-26 at 9.49.32 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce99734192414c28f60ee55af1e0b2f0ca47477e.png) ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [February 26, 2022, 1:53pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/11 "2022-02-26T13:53:19Z")
![doubtn2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/13d19e73be985c08efcd503afeec99a0660f9cf6.png) same has been given. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [February 26, 2022, 2:08pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/12 "2022-02-26T14:08:48Z")
I think you haven’t formatted that date column in you google sheet as Date. Go to your sheet and select that column and go to the Format tab and select Number\>Date. And come back to Glide and refresh the Data Editor ( click the small refresh icon) and check. ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [February 26, 2022, 2:25pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/13 "2022-02-26T14:25:42Z")
Now i got the date.but can i use this in filter ? i need to filter with this date.i already one filter with shop name.but showing only 2 results in drop down date is empty and date is not empty. ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [February 26, 2022, 2:38pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/14 "2022-02-26T14:38:36Z")
No issues.i use visibility to restrict data by date.Thanks ---
**Author:** ![Fernanda\_Rojas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fernanda_rojas/32/57241_2.png) [@Fernanda\_Rojas](https://community.glideapps.com/u/Fernanda_Rojas)\ **Post date:** [September 10, 2024, 4:38pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/15 "2024-09-10T16:38:14Z")
Hi, I am running into this situation where I have the date as a lookup, but cannot do anything with that field. When I tried applying a new math column that references to the lookup field, it does not give the option to select it, I believe it has changed. Is there any other solution? Thank you ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [September 10, 2024, 4:49pm UTC](https://community.glideapps.com/t/date-column-is-a-lookup/38969/16 "2024-09-10T16:49:31Z")
Hola Fernanda! is your relation simple o multiple? To work with a math column your relation must be simple, otherwise you will receive an array which can’t be referenced by some columns Saludos!