# Showing different date than on Google sheet **URL:** \ **Category:** Report a Bug\ **Created:** [September 5, 2020, 1:43pm UTC](https://community.glideapps.com/t/showing-different-date-than-on-google-sheet/15315 "2020-09-05T13:43:17Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 5, 2020, 1:43pm UTC](https://community.glideapps.com/t/showing-different-date-than-on-google-sheet/15315/1 "2020-09-05T13:43:17Z")
I have a list of books with dates published and one of them has just the year 2003, but on the app, it shows as Jan 1 1970(!!!). Any ideas? ![IMG_4254](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6f261f10089f30bcd1d8afae8ed6d5580c653de7.jpeg) ![Screen Shot 2020-09-05 at 3.32.42 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/907451b51b9c5661291242dff32c3fa05b995136.png) I can even see this weird date on the data on Glide but when I click in, I see the correct date. See video. > **[IMG\_4255.MOV (video)](https://drive.google.com/file/d/1AAhuCIo0KU9WC_ZI-DvMu0KheCn5PtZd/view?usp=sharing)** > > Google Drive file. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 5, 2020, 1:52pm UTC](https://community.glideapps.com/t/showing-different-date-than-on-google-sheet/15315/2 "2020-09-05T13:52:58Z")
The number 2003 is not a date (which month? Which day?) ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 5, 2020, 2:44pm UTC](https://community.glideapps.com/t/showing-different-date-than-on-google-sheet/15315/3 "2020-09-05T14:44:04Z")
That’s all I have for this book. Why is it showing 1970? ---
**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:** [September 5, 2020, 2:58pm UTC](https://community.glideapps.com/t/showing-different-date-than-on-google-sheet/15315/4 "2020-09-05T14:58:41Z")
Unix dates start on Jan 1st 1970. 2003 as a date is very well below a date of 20030101 in unix terms, so it defaults to the start date of the epoch. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 5, 2020, 2:59pm UTC](https://community.glideapps.com/t/showing-different-date-than-on-google-sheet/15315/5 "2020-09-05T14:59:38Z")
Computers often represent dates as the number of seconds elapsed since January 1, 1970: [https://en.wikipedia.org/wiki/Unix\_time](https://en.wikipedia.org/wiki/Unix_time) So, I think Glide interprets this date as “2003 seconds after midnight, January 1, 1970” ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 5, 2020, 4:05pm UTC](https://community.glideapps.com/t/showing-different-date-than-on-google-sheet/15315/6 "2020-09-05T16:05:01Z")
Oh ok. 😛. This is a real life use case, where I don’t actually have the full date. Maybe in this kind of case just show what I enter? ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 5, 2020, 5:04pm UTC](https://community.glideapps.com/t/showing-different-date-than-on-google-sheet/15315/7 "2020-09-05T17:04:53Z")
Make a new text column called “Approximate Date” and an If Then Else that shows the Approximate Date if the date field is empty. Then you can write things like “Unknown” or “1000 B.C.” or “Fall 2019”. In Glide, every column has a type. You cannot have a Date column where some of the values are not dates.