You need to sign in to do that
Don't have an account?
Manvitha
Extract date,ime and user from lastmodified by ?created by field
Hi All,
How would I create a formula that extracts the time from a LastModifiedDate field. For example:
Last Modified By = David Levins, 1/31/2012 9:58 AM
Want user name concatinated Time Stamp custom formula field to equal "9:58 AM"
I have created 1 custom object , in that i want fetch this detail in custom formula field where formula of this field should be like this
User Name concatenated with lastmodifieddate( but i dont want to use this i tried like SUBSTITUTE(TEXT( LastModifiedDate ), TEXT( DATEVALUE( LastModifiedDate)) , '') this gave me time in zulu timezone
Thank you in Advnc.
How would I create a formula that extracts the time from a LastModifiedDate field. For example:
Last Modified By = David Levins, 1/31/2012 9:58 AM
Want user name concatinated Time Stamp custom formula field to equal "9:58 AM"
I have created 1 custom object , in that i want fetch this detail in custom formula field where formula of this field should be like this
User Name concatenated with lastmodifieddate( but i dont want to use this i tried like SUBSTITUTE(TEXT( LastModifiedDate ), TEXT( DATEVALUE( LastModifiedDate)) , '') this gave me time in zulu timezone
Thank you in Advnc.
What is the issue here??
Thanks!!