Deleting a date

chemi · 03-01-2013, 06:07 AM

I have a date field. By default it is blank.
Once I enter a value... I haven't found a way to remove it. I mean, I want to have a date for some books but for others the date field should be blank or unknown.

Is this possible?

Thanks in advance,

Chemi

JimmyR · 03-01-2013, 06:19 AM

Select a book, Click "Edit Meta Data". To the right of the meta data fields, you'll see green recycle icons. Clicking those will clear the associated field, the Date field included.

chemi · 03-01-2013, 06:30 AM

Thanks!

chaley · 03-01-2013, 06:35 AM

Quote:

Originally Posted by chemi

I have a date field. By default it is blank.
Once I enter a value... I haven't found a way to remove it. I mean, I want to have a date for some books but for others the date field should be blank or unknown.

I assume that the date is a custom column.

Three ways to clear a custom date:

1) In edit metadata (single), click the "Clear" button under the box for the date.

2) In edit metadata (multiple), click the "Apply changes" box leaving the date empty.

3) In the spreadsheet view, change the date to year: 0101, month: 01, day: 01. (And no, there isn't a way to add a "clear button" here).

theducks · 03-01-2013, 09:05 AM

Since you had the answer to Date.

How do you blank (Not just set it to Zero) a Custom Column number field (in my case #pages) ?

chaley · 03-01-2013, 09:50 AM

Quote:

Originally Posted by theducks

Since you had the answer to Date.

How do you blank (Not just set it to Zero) a Custom Column number field (in my case #pages) ?

set it to -1000000, or use the process described in the thread Reset book's numeric field to blank.

theducks · 03-01-2013, 12:03 PM

Quote:

Originally Posted by chaley

set it to -1000000, or use the process described in the thread Reset book's numeric field to blank.

I had missed that one

BetterRed · 03-01-2013, 09:08 PM

Quote:

Originally Posted by chaley

...And no, there isn't a way to add a "clear button" here).

If that situation were to change, it would be cute to have a "today's date" button too

BR

HFC3 · 07-07-2013, 04:35 PM

This doesn't work for custom date fields. The "date" field clearly visible in the Metadata window appears to be an Calibre record create date. Clearing that with the recycle icon works, but doesn't help with the same issue on other, custom, date fields.

I noticed the "Tag" metadata drop down. This is showing some of my custom fields, but not all. I know why a column built from another column wouldn't appear - I purposely didn't pic the option that indicated the new field would behave like a tag.

But, but there are is one date and number custom field type, neither of which specify "behave like tag". So, no column created as a date or number types are appearing in the tag list.

Where do you access them that has a recycle icon to clear the value?

???

theducks · 07-07-2013, 05:17 PM

Quote:

Originally Posted by HFC3

This doesn't work for custom date fields. The "date" field clearly visible in the Metadata window appears to be an Calibre record create date. Clearing that with the recycle icon works, but doesn't help with the same issue on other, custom, date fields.

I noticed the "Tag" metadata drop down. This is showing some of my custom fields, but not all. I know why a column built from another column wouldn't appear - I purposely didn't pic the option that indicated the new field would behave like a tag.

But, but there are is one date and number custom field type, neither of which specify "behave like tag". So, no column created as a date or number types are appearing in the tag list.

Where do you access them that has a recycle icon to clear the value?

???

Custom Date columns come with a 'Clear Date' button in the metadata editor

You can't have a 'date' list tag . Tags lists are TEXT (includes digits)

HFC3 · 07-07-2013, 05:30 PM

Ah. That's in the "Custom Metadata" tab.

Thanks again!

BetterRed · 07-07-2013, 08:40 PM

You can clear a date in the spreadsheet by highlighting the field, then press F2-enter

You can set a date in the spreadsheet to today by highlighting the field, then press F2=enter

Much easier than clicking buttons in metadata edit.

BR

HFC3 · 07-07-2013, 11:47 PM

No true, if by "Spreadsheet" is the main Calibre display table - F2 and blanking the date just replaces the original value when you press >Enter<. That was the first thing I tried.

If that's not what you mean, then why would modifying spreadsheet have any effect on the Calibre table?

davidfor · 07-08-2013, 02:21 AM

BetterRed meant: Press F2, make sure all the text is selected, press the "-" key and then press enter. That will clear the date. Pressing the "=" key with set it to the current date.

BetterRed · 07-08-2013, 04:39 AM

Quote:

Originally Posted by davidfor

BetterRed meant: Press F2, make sure all the text is selected, press the "-" key and then press enter. That will clear the date. Pressing the "=" key with set it to the current date.

BR meant exactly what he wrote

After I press F2 on ANY editable cell in the spreadsheet the content of the cell is always selected - to un-select it I must press home, end, left arrow or right arrow.

There is no need to check anything. To clear a date just press the F2 key, followed by the '-' key, followed by the Enter key; use the '=' to set to today. If you change your mind exit the cell edit with Escape.

BR

03-01-2013, 06:07 AM	#1
chemi Member Posts: 18 Karma: 10 Join Date: Jan 2013 Device: Sony Reader PRS-T2	Deleting a date I have a date field. By default it is blank. Once I enter a value... I haven't found a way to remove it. I mean, I want to have a date for some books but for others the date field should be blank or unknown. Is this possible? Thanks in advance, Chemi

03-01-2013, 09:05 AM	#5
theducks Well trained by Cats Posts: 29,777 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	'Unassign' a custom Number field Since you had the answer to Date. How do you blank (Not just set it to Zero) a Custom Column number field (in my case #pages) ?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Publication Date or Copyright Date or ???	hd_cal_dave	Library Management	8	05-25-2012 01:50 PM
Date Added vs. Date Modified	aglaia761	Calibre	5	11-28-2010 05:34 AM
Bulk Changing Published Date To Date	hmf	Calibre	4	10-19-2010 10:19 PM
Up-to-date candy teacher (date being 1921)	kacir	Deals and Resources (No Self-Promotion or Affiliate Links)	0	06-16-2010 04:18 PM
new official shipping date / US invitation date	R2D2	iRex	18	07-06-2006 02:32 PM

03-01-2013, 06:19 AM	#2
JimmyR ɴₐɴ Posts: 421 Karma: 2507940 Join Date: Jun 2011 Location: 37.2N 93.3W Device: KV PW4 PW3 PW2	Select a book, Click "Edit Meta Data". To the right of the meta data fields, you'll see green recycle icons. Clicking those will clear the associated field, the Date field included.

03-01-2013, 06:30 AM	#3
chemi Member Posts: 18 Karma: 10 Join Date: Jan 2013 Device: Sony Reader PRS-T2	Thanks!

07-07-2013, 04:35 PM	#9
HFC3 Enthusiast Posts: 30 Karma: 10 Join Date: Apr 2013 Device: Kindle Touch	This doesn't work for custom date fields. The "date" field clearly visible in the Metadata window appears to be an Calibre record create date. Clearing that with the recycle icon works, but doesn't help with the same issue on other, custom, date fields. I noticed the "Tag" metadata drop down. This is showing some of my custom fields, but not all. I know why a column built from another column wouldn't appear - I purposely didn't pic the option that indicated the new field would behave like a tag. But, but there are is one date and number custom field type, neither of which specify "behave like tag". So, no column created as a date or number types are appearing in the tag list. Where do you access them that has a recycle icon to clear the value? ???

07-07-2013, 05:30 PM	#11
HFC3 Enthusiast Posts: 30 Karma: 10 Join Date: Apr 2013 Device: Kindle Touch	Ah. That's in the "Custom Metadata" tab. Thanks again!

07-07-2013, 08:40 PM	#12
BetterRed null operator (he/him) Posts: 20,544 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	You can clear a date in the spreadsheet by highlighting the field, then press F2-enter You can set a date in the spreadsheet to today by highlighting the field, then press F2=enter Much easier than clicking buttons in metadata edit. BR

07-07-2013, 11:47 PM	#13
HFC3 Enthusiast Posts: 30 Karma: 10 Join Date: Apr 2013 Device: Kindle Touch	No true, if by "Spreadsheet" is the main Calibre display table - F2 and blanking the date just replaces the original value when you press >Enter<. That was the first thing I tried. If that's not what you mean, then why would modifying spreadsheet have any effect on the Calibre table?

07-08-2013, 02:21 AM	#14
davidfor Grand Sorcerer Posts: 24,907 Karma: 47303748 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	BetterRed meant: Press F2, make sure all the text is selected, press the "-" key and then press enter. That will clear the date. Pressing the "=" key with set it to the current date.