Thread: How do I clear a date field?
View Single Post
Old 11-04-2015, 09:33 PM   #5
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,094
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by BetterRed View Post
@truth1ness - IIRC: it's because dates are numbers, most columns are strings. Integer and floats are also cleared with '-'.

BR
Dates are really timestamps, a special DB type that is processed for the display you see. In addition, Calibre includes a Calendar tool as part of the field display

IIRC 1/1/101 is a special date that the process will nil out the timestamp
theducks is offline   Reply With Quote