What is the Date Column called in the Search Field?

JDesat · 03-21-2025, 06:49 PM

I know this is a stupid question, but "date" isn't an option even though when you hover on the Date column it says that is what it's called. I'm trying to "Search and Replace" from the Date column into a "Last Read" custom column because I got a new Kobo and want things to be in roughly the same order (I sort by 'recent' on my Kobo) and Kobo Utilities will let me do that using the last read column.

I've done this before, but it's been several years. I know the regular expressions to use, but none of the columns I'm selecting in the search field are the right one.

ownedbycats · 03-21-2025, 07:17 PM

try timestamp. It's a weird column with two names.

Click image for larger version

Name: 2025-03-21 20_20_02-Editing metadata for one book.png
Views: 42
Size: 47.1 KB
ID: 214516

theducks · 03-21-2025, 07:46 PM

Another option: select field: {template} from the list, then enter {date} into the search feild box

ownedbycats · 03-21-2025, 07:54 PM

Quote:

Originally Posted by theducks

Another option: select field: {template} from the list, then enter {date} into the search feild box

if important, raw_field('date') copies the time, while {timestamp}/{date} doesn't (resets it to 00:00).

03-21-2025, 06:49 PM	#1
JDesat Connoisseur Posts: 99 Karma: 32768 Join Date: Dec 2012 Device: Kobo Glo HD, Kobo Clara HD	What is the Date Column called in the Search Field? I know this is a stupid question, but "date" isn't an option even though when you hover on the Date column it says that is what it's called. I'm trying to "Search and Replace" from the Date column into a "Last Read" custom column because I got a new Kobo and want things to be in roughly the same order (I sort by 'recent' on my Kobo) and Kobo Utilities will let me do that using the last read column. I've done this before, but it's been several years. I know the regular expressions to use, but none of the columns I'm selecting in the search field are the right one. Last edited by JDesat; 03-21-2025 at 06:59 PM.

03-21-2025, 07:17 PM	#2
ownedbycats Custom User Title Posts: 10,694 Karma: 74166147 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	try timestamp. It's a weird column with two names. Last edited by ownedbycats; 03-21-2025 at 07:20 PM.

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
Custom Column question - Date field was last modified	Comfy.n	Calibre	12	09-21-2022 01:10 AM
Automatically Setting Date field to file creation date when importing.	Marc_G2	Library Management	6	07-25-2020 10:35 PM
Search for column "date"	huber70	Library Management	4	12-06-2019 01:29 PM
Find empty date column in search	Tiggy626	Library Management	2	09-24-2018 08:03 PM
Problem copying a date column to other date column	Terisa de morgan	Library Management	13	05-01-2016 03:27 AM

03-21-2025, 07:46 PM	#3
theducks Well trained by Cats Posts: 30,912 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Another option: select field: {template} from the list, then enter {date} into the search feild box