04-23-2013, 10:03 AM | #1 |
Enthusiast
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. |
04-23-2013, 11:07 AM | #2 |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
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())'} Code:
program: days_between(field('#releasedate'), today()) |
Advert | |
|
04-23-2013, 01:02 PM | #3 |
Enthusiast
Posts: 25
Karma: 10
Join Date: Mar 2013
Location: Canada
Device: iPhone, iPad, Sony, Kobo
|
Thank you. worked like a charm
|
|
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 |