[Skydog]

Originally Posted by davidfor

That is the column to store the last time read when it is fetched from the device.


The second column has the column type "Column built from other columns". The lookup name and column heading are whatever you want. So, the heading is probably "Finished", and you can use "finished" for the lookup name. You set the template to what I first posted. And you set the "Sort/search column by" to "Date". With that, the column will show either nothing (the percent read is less than 100) or the date retrieved from the device when the book was finished (the percent read is 100).

Thank you, davidfor. Unfortunately, no success. The "Finished" column remains blank, only the the "Last Read" column contains entries:

Lookup name: kobolastread
Column heading: Last Read
Column type: Date

Lookup name: finished
Column heading: Finished
Column type: Column built from other columns
Template:

program:
cmp($$#kobo_percent_read, 100, '', format_date($$#kobo_last_read,'dd MMM yyyy'), format_date($$#kobo_last_read,'dd MMM yyyy'));