function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
ManvithaManvitha 

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.
AnkaiahAnkaiah (Salesforce Developers) 
Hi Manasa,

What is the issue here??

Thanks!!