# Date-time before time 13:00 not showing after copy/paste or export/import of date
**URL:** https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335
**Category:** Report a Bug
**Created:** [January 31, 2024, 7:14pm UTC](https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335 "2024-01-31T19:14:09Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Pau\_Lund-Larsen](https://community.glideapps.com/u/Pau_Lund-Larsen)
#### Post date: [January 31, 2024, 7:14pm UTC](https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335/1 "2024-01-31T19:14:09Z")
**Team ID:**
[go.glideapps.com/o/99cakGb1llPgaq2NXPfy](http://go.glideapps.com/o/99cakGb1llPgaq2NXPfy)
**App ID:**
[go.glideapps.com/app/JLuyHh6JakfsJ2u6XOsd](http://go.glideapps.com/app/JLuyHh6JakfsJ2u6XOsd)
**Description**
When copying a date field either through copy/paste or export/import in the data editor then any date with a time before 13:00 doesn’t show in the data editor or in the layouts where it’s used. Editing the date in the data editor works fine. And changing the time to after 13:00 will make it show. Changing it back to before it’ll disappear. Changing existing times after 13:00 to before 13:00 manually in the data editor also make them disappear.
**How to replicate**
Copy the dates in blue to below:
The date with timestamp 11:28 is now missing
When editing the field it appears while editing
If changing the time manually to 13:28 it reappears after ending editing
If changing it back to 11:28 i disappears again. Same if changing the other date-times to any time before 13:00.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 1, 2024, 12:26am UTC](https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335/2 "2024-02-01T00:26:40Z")
What does your first row look like when you click on it? Does it look like “7.1.2023 11.28.11” as well?
Does it work if you change the underlying formatting of row 1 to “7.1.2023 11:28:11” and copy it to row 4?
I think 11.28.11 might be throwing the “reader” off. Usually you see hh:mm:ss, not hh.mm.ss.
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [February 1, 2024, 1:23pm UTC](https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335/3 "2024-02-01T13:23:45Z")
I agree with Thinh. If the output is buggy for values 12 and below, but not buggy for values 13 and above, it looks like the editor is interpreting that value as a month rather than an hour.
I find dates and times really tricky. Tricky to understand, tricky to work with. It helps to keep things simple to stay out of trouble.
Here are a few tips:
– Writing dates –
Avoid writing dates manually. Use a picker instead. If done via import, be weary of the format of the date column in the source.
– Relations –
Anytime you create a relation with a date, convert the date to either a string (template column) or a number (math column). This will avoid issues with different date formats from device to device.
– How to convert a raw date to an integer in YYYYMMDD format with a Math column –
Year(date)\*10^4+Month(date)\*10^2+Day(date)
– Date vs Date-Time –
In the Date & Time column, the configuration to “date only” or “time only” only affects what is displayed in the layout editor and app. Under the hood in the data editor, both the date and time are stored.
– On or After // On or Before // After // Before in conditions (visibility, filter, if-then-else columns) –
• On or After // On or Before: Date only. Ignores the time (because of ‘on’).
• Before // After: Date and time. Takes the time into account.
– Change the format of a date –
Using the Format Date column directly on raw date values is not recommended, as it often leads to issues. Instead, transform the date-time value into a date only that Glide can interpret:
1. Convert the raw date to an integer in YYYYMMDD format using a Math column.
2. Create a new date from this integer with a ‘Text to Date’ computed column.
3. Use this new date in a ‘Format Date’ computed column.
The initial 2 steps ensure you’re working with an unambiguous date and a date only rather than date and time. ‘Format Date’ then becomes more reliable.
Thank you to @jeff, @Darren_Murphy, @mattbrowning and @Oscar_V88 for their input.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 1, 2024, 1:31pm UTC](https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335/4 "2024-02-01T13:31:35Z")
Excellent summary. Bookmarked.
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [February 1, 2024, 1:33pm UTC](https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335/5 "2024-02-01T13:33:58Z")
I’m not sure if this list is “complete”. Once it is, we could add it in the community resources section.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 1, 2024, 1:42pm UTC](https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335/6 "2024-02-01T13:42:49Z")
It’s covered most of the important things. “What every Glide developer should know about working with Dates & Times”
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [February 1, 2024, 5:27pm UTC](https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335/7 "2024-02-01T17:27:59Z")
> [@nathanaelb](#):
>
> I’m not sure if this list is “complete”. Once it is, we could add it in the community resources section.
It’s enough to start with. 😉
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [February 1, 2024, 5:32pm UTC](https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335/8 "2024-02-01T17:32:09Z")
I don’t start anything because I refuse to if things are not already perfect from the outset 😂 The story of my life. I’ll bite the bullet and create the topic for the community resources.
---
### Author:  [@Pau\_Lund-Larsen](https://community.glideapps.com/u/Pau_Lund-Larsen)
#### Post date: [February 1, 2024, 5:55pm UTC](https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335/9 "2024-02-01T17:55:41Z")
Thanks for you input - appreciated.
Bonus info:
1. The original dates are written to the db from a standard Glide date picker. Nothing custom. The copied dates obviously come from the copy action of which I have tried simple keyboard copy/paste and glide table export/import. Same result.
2. The first date/time on the list:
…has the exact same underlying format when being edited manually in the data editor: “7.1.2023 11.28.11”. If I edit it manually in the field where it was originally added via the glide date/time picker it works fine. But copying the field or the underlying text value on edit to another field it fails as described.
3. I have also tried to copy the text via notepad to get rid of any hidden characters. That didn’t change a thing.
4. I can confirm that changing to “7.1.2023 11:28:11” (colon instead of dot) works! But in that case I guess that the bug is that the original date from the date picker in my scenario for some reason is shown and exported as “7.1.2023 11.28.11”!
Can’t you guys replicate? I’m in Denmark. Maybe a localisation issue somehow?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 2, 2024, 12:11am UTC](https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335/10 "2024-02-02T00:11:09Z")
If that did indeed come from the date picker then I think it’s a bug. I expected the picker to write a Zulu format under the hood though.
> [@How to open a support ticket?](https://community.glideapps.com/t/how-to-open-a-support-ticket/59883/2):
>
> Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the [Glide Support Page](https://www.glideapps.com/support). To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: Glide will prompt you to create a support link for your App. Click on Create Link:
Please open a support ticket.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [July 31, 2024, 12:11am UTC](https://community.glideapps.com/t/date-time-before-time-13-00-not-showing-after-copy-paste-or-export-import-of-date/70335/11 "2024-07-31T00:11:13Z")
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.