03-28-2013, 02:58 AM | #1 | ||
Junior Member
Posts: 3
Karma: 1806
Join Date: Mar 2013
Device: laptop
|
Rounding to nearest integer in Custom Column - Hijri Year
Hello,
I have a column for the year the book was written in the Gregorian calendar, and also another column for the year in the Hijri Lunar calendar I called the first column gyear, and the second column hyear. they are related by the simple formula hyear = (33/32)*(gyear - 622) So made a column built from other columns, and called it hyear and gave it the following template, Quote:
Quote:
Please let me know how to do this, I am sure it is a very simple feature I simply overlooked. Thanks Last edited by oelgamal; 03-28-2013 at 02:53 PM. Reason: added formula |
||
Tags |
custom columns, date, format, rounding |
|
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 |