# Issue clearing date time picker **URL:** \ **Category:** Report a Bug\ **Created:** [May 27, 2020, 10:28am UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865 "2020-05-27T10:28:52Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Ed\_V](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed_v/32/2667_2.png) [@Ed\_V](https://community.glideapps.com/u/Ed_V)\ **Post date:** [May 27, 2020, 10:28am UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/1 "2020-05-27T10:28:52Z")
When using my app in the browser and attempting to clear a date time picker it consistently outputs 12/30/1899 0:00:00 instead of going blank. When attempting to clear a date time picker on my or another user’s phone it doesn’t let you at all. Has anyone else encountered this? ---
**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:** [May 27, 2020, 11:53am UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/2 "2020-05-27T11:53:03Z")
> [@IOS issue with Deselecting or clearing Date/Time Entries](https://community.glideapps.com/t/deselecting-date-time-entries/9500): > > My app’s URL: [https://2fztf.glideapp.io/](https://2fztf.glideapp.io/) We are using the Date/Time component for learners to indicate an activity has been completed. However, considering there might be instances where folks accidentally select this or realize they aren’t complete, we are realizing there isn’t a way to “Clear” the date/time field. When selected there is a “Clear” option on date/time selection wheels; however, nothing happens when you select clear. In some instances, we have noticed it does not clear, but ulti… ---
**Author:** ![Nathaniel\_Strauss](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathaniel_strauss/32/7864_2.png) [@Nathaniel\_Strauss](https://community.glideapps.com/u/Nathaniel_Strauss)\ **Post date:** [May 27, 2020, 5:30pm UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/3 "2020-05-27T17:30:52Z")
Same here. Date and date time picker are not able to clear the field. Tested this on computer (Mac with Chrome) and iOS/iPadOS. I would expect the value to be blank/null. Instead when I tap the clear button nothing happens. Definitely a bug. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [July 21, 2020, 9:07pm UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/4 "2020-07-21T21:07:58Z")
@Mark This is a necessity. There should be some way to clear a date/time component and have the sheet result in a null value. Thanks! ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [July 21, 2020, 9:43pm UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/5 "2020-07-21T21:43:35Z")
Ageed this is a pain I have had (and my users) for some time now. I know it can be done, just don’t know why this is an issue within glide. ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [July 21, 2020, 9:45pm UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/6 "2020-07-21T21:45:52Z")
Caused me a problem only today. Reported by user. Is there a workaround? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [July 21, 2020, 9:59pm UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/7 "2020-07-21T21:59:55Z")
The workaround I’ve created at this point is To have a input text component somewhere near the date time picker whether that be in a button that links to screen or an edit section of the screen that displays the same column as the date time picker column. When users clear the text the date time value gets deleted and results in a null value. Not the best UI, but it works. ---
**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:** [July 21, 2020, 10:57pm UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/8 "2020-07-21T22:57:10Z")
Would an increment button work here? What happens when you increment a value of 0 to a date column? I imagine the setup would be a button that says update your date time here, when you press that, a date time picker component will come up and it will only come up when the value of the cell is 0. Not sure it will actually show 0 or not, but that was the trick I used to update a location component. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [July 21, 2020, 11:13pm UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/9 "2020-07-21T23:13:21Z")
I tried incrementing by 1, not 0, with failed results…not sure! ---
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [July 29, 2020, 10:08pm UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/10 "2020-07-29T22:08:14Z")
Increment -100000000000000 (14 zeros) **Sheet (Before):** ![snip1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b77ba63ee62dd92d6eb5f348942345ceec97c6ab.png) **Clearing:** ![picker](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1e330cca290d3e46051b336d51b7ebcc21e290de.gif) **Sheet (After):** ![snip2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/475fd836be6c1a2920238534e0c7fd2095a072e8.png) ---
**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:** [July 29, 2020, 10:51pm UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/11 "2020-07-29T22:51:39Z")
Thanks for this, looks neat! I think it has to do with the Unix format. As Unix contains 13 numbers, the action of taking 100000000000000 units from it clear the picker. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6c6c00ad0c3b92efc26ec2598ddd97644659f9e1.png) ---
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [July 29, 2020, 10:57pm UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/12 "2020-07-29T22:57:43Z")
Exactly right. I counted the # digits comprising the date (8 for mm/dd/yyyy) + time (6 for hh:mm:ss). It’s not a true clear but close. ---
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [July 30, 2020, 6:25am UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/13 "2020-07-30T06:25:30Z")
I was thinking about this some more. Anything less than 14 zeros fails for me. But Unix Time, if I’m understanding the concept correctly, is not absolute. - 07/11/2007 @ 1:10am (UTC) is represented as 1184116212 (10 digits). - Today, 7/29/2020 @ 11:12pm (PST) is 1596064320 (10 digits). How are you generating 13 numbers? ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [July 30, 2020, 7:42am UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/14 "2020-07-30T07:42:43Z")
That’s a neat trick, bookmarking for trying out later thanks 😊 ---
**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:** [July 30, 2020, 8:43am UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/15 "2020-07-30T08:43:01Z")
![Screen Shot 2020-07-30 at 15.42.49](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7f3f00c74d2fcaec39ffe5468c02c6ad9c4c50ad.png) I guess it includes milliseconds. ---
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [August 8, 2020, 4:41am UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/17 "2020-08-08T04:41:33Z")
A reset [x] just made an appearance! I’ve been able to clear the dates in the picker itself but it will not clear the dates in GS. Will be curious to hear others’ experiences. ![Image 2020-08-07 at 9.35.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/723aef3dbb34f549b731d6718ed9906c5aef1c2c.png) ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [August 8, 2020, 4:55am UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/18 "2020-08-08T04:55:11Z")
Not checked gs yet but noticed the clear button icon only appears when using _ **date and tIme** _ but _ **not** _ on _ **date only** _ ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e7e9a7bfef698927b15e92ee02959fdb705ddb91.jpeg) ---
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [August 8, 2020, 5:03am UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/19 "2020-08-08T05:03:22Z")
That’s odd. Date/time(s) already in GS make their way back in after clearing unless a new date/time is selected. ---
**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 11, 2024, 10:59am UTC](https://community.glideapps.com/t/issue-clearing-date-time-picker/9865/20 "2024-02-11T10:59:04Z")