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. :) ________________________________ ____________________________________________________________________________ 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
