Hi Paul,
Create a column called Days Absent and select the field type "Calculated (calculation based on other columns)" and select a return type of number. Also reverse your formula e.g. =DATEDIF([Start Date],[End Date],"d") cheers Clayton James From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Noone Sent: Wednesday, 16 July 2008 2:53 PM To: [email protected] Subject: [OzMOSS] Custom list calculated value for default column value Hi, I've created a custom list which has columns for start and end date. I have a third column (number) for Days Absent which I'd like to assign a default calculated value based on =DATEDIF([End Date], [Start Date],"d"). Unfortunately I keep getting the error: "The formula contains reference(s) to field(s)." I'm sure I'm missing something obvious. Kind regards, Paul ________________________________ ________________________________________________________________________ ____ This e-mail is intended for the use of the addressed recipient(s) only and may contain confidential and privileged information. If you have received this message in error, please delete the message and any attachments and copies immediately; and notify the sender by return e-mail. Any views expressed in this message or any attachments are those of the individual sender and do not necessarily represent the corporate opinion of the Catholic Education Office (CEO), Sydney. The CEO Privacy Policy is located at http://www.ceo.syd.catholic.edu.au ________________________________________________________________________ ____ ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com Internal Virus Database is out-of-date. Checked by AVG. Version: 7.5.524 / Virus Database: 270.4.7/1543 - Release Date: 9/07/2008 6:32 PM ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
