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

Reply via email to