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: 12,525
Karma: 8065948
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
|
|
|
|
 |
«
Previous Thread
|
Next Thread
»
| Thread Tools | Search this Thread |
|
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 01:07 PM.