I'm hiding the column from the form view as I want to give it a unique name, i.e.:
=[Employee Name]& DATE(YEAR(Today),MONTH(Today),DAY(Today)) Unfortunately [Employee name] is a User lookup field and so can't be used in this way, I don't think. So, at present I have: ="Leave request - "&TEXT(Today,"dd-mm-yyyy") Which returns: Leave request - 17-07-2008 It's a great start but not ideal. I'd like to be able to get hh:mm:ss after the date (not sure how) and change "Leave request - " to the employee name. e.g. Paul Noone - 17-07-2007 11:54:28 Regards, Paul Online Developer, ICT CEO Sydney From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caroline Specker (AU) Sent: Thursday, 17 July 2008 11:44 AM To: [email protected] Subject: [OzMOSS] RE: Create timestamp for column Do you need to convert the date to a string? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Noone Sent: Thursday, 17 July 2008 10:58 AM To: [email protected] Subject: [OzMOSS] Create timestamp for column I'm trying to give a hidden Title column a timestamp "yyyy/mm/dd hh:mm:ss" or random value of some kind using its Default value: Calculated value. I've used - =DATE(YEAR(Today),MONTH(Today),DAY(Today)) - which gets accepted but returns nothing. The Today function doesn't appear to work and there doesn't seem to be a NOW equivalent or simple function to enter the seconds since epoch, or even a random number. I can't delete or change the type for the Title column because the content type uses Item as a parent. Is there some other way to get the hyperlink/action functionality for a column? Or should I have started with another content type as parent? Any suggestion (apart from creating extra columns) appreciated. Ugh. Soz. Been a long week. J ________________________________ ________________________________________________________________________ ____ 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 ************************************************************************ ****** - NOTICE FROM DIMENSION DATA AUSTRALIA This message is confidential, and may contain proprietary or legally privileged information. If you have received this email in error, please notify the sender and delete it immediately. Internet communications are not secure. You should scan this message and any attachments for viruses. Under no circumstances do we accept liability for any loss or damage which may result from your receipt of this message or any attachments. ************************************************************************ ****** ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ____________________________________________________________________________ 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
