|04-23-2013, 11:03 AM||#1|
Join Date: Mar 2013
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, 12:07 PM||#2|
"chaley", not "charley"
Join Date: Jan 2010
Device: PRS-300, Galaxy Nexus, Nexus 7, HTC Sensation, Galaxy Tab 10.1
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
program: days_between(field('#releasedate'), today())
|Thread Tools||Search this Thread|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Custom yes/no column built from long text column||Philantrop||Library Management||7||03-23-2013 08:44 PM|
|how to move value(s) of tag column to a custom made column||zoorakhan||Library Management||0||12-08-2012 04:53 AM|
|custom date column from two state column||Dopedangel||Library Management||7||01-03-2012 09:20 AM|
|help with custom column||Noughty||Library Management||4||10-15-2011 06:31 AM|
|Can custom book data be displayed in a custom column?||kiwidude||Development||9||03-02-2011 06:35 AM|