Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 04-23-2013, 10:03 AM   #1
rifka
Enthusiast
rifka began at the beginning.
 
Posts: 25
Karma: 10
Join Date: Mar 2013
Location: Canada
Device: iPhone, iPad, Sony, Kobo
Custom Column - Days_Between

Good morning I need help creating a custom column. I have tried and I just can't make it work.

I have a column:
Lookup name: releasedate
Column heading: Release-Date
Column Type: Date

This column is a manually entered date for expected publication date.

What I would like is a custom column for days between calculating the days between today and releasedate. I know there is a function today(), and a function days_between but I can't figure out how to use them. I also can't figure out if I need to create a separate custom column for today first.

Someone please help. Thank you.
rifka is offline   Reply With Quote
Old 04-23-2013, 11:07 AM   #2
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 11,691
Karma: 6240117
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Create a custom column "built from other columns". Assuming that #releasedate is in the future and that you want to see a positive number, using template program mode the template for the new column is
Code:
{#releasedate:'days_between($, today())'}
Using general program mode the template is
Code:
program: days_between(field('#releasedate'), today())
chaley is offline   Reply With Quote
Advert
Old 04-23-2013, 01:02 PM   #3
rifka
Enthusiast
rifka began at the beginning.
 
Posts: 25
Karma: 10
Join Date: Mar 2013
Location: Canada
Device: iPhone, iPad, Sony, Kobo
Thank you. worked like a charm
rifka is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom yes/no column built from long text column Philantrop Library Management 7 03-23-2013 07:44 PM
how to move value(s) of tag column to a custom made column zoorakhan Library Management 0 12-08-2012 03:53 AM
custom date column from two state column Dopedangel Library Management 7 01-03-2012 08:20 AM
help with custom column Noughty Library Management 4 10-15-2011 05:31 AM
Can custom book data be displayed in a custom column? kiwidude Development 9 03-02-2011 05:35 AM


All times are GMT -4. The time now is 10:55 PM.


MobileRead.com is a privately owned, operated and funded community.