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.
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.
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.
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).
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.