Need Help with Formula Field

Question

Hi Folks, Need help with Formula Field. I'm using Action Layout to display few fields that includes created By System Field. The Created By field show's the name of the user who created the record but it does not show the CreatedDateTime. I know Created By and Created date are not supported in Action layout Editor, that is why I'm creating a formula field to show Created By and Created DateTime. The formula is as follows:-

Return Type: Text

HYPERLINK("/", CreatedBy.FirstName& " " &CreatedBy.LastName, "_self" )& ","& " " &TEXT( CreatedDate )

Output:-

Any Idea how I can get like as shown Below:-

Thanks!!

Sunil Sarilla · Accepted Answer

Hi Gotham,

Please try the below

HYPERLINK("/", CreatedBy.FirstName& " " &CreatedBy.LastName, "_self" )& ","& " " &TEXT( MONTH(DATEVALUE(CreatedDate )))&"/"&TEXT( DAY(DATEVALUE(CreatedDate )))&"/"&TEXT( YEAR(DATEVALUE(CreatedDate )))&" "&MID( TEXT( CreatedDate - 5/24 ), 12, 2 )&":"&MID( TEXT( CreatedDate - 5/24 ), 15, 2 )&" "&IF(VALUE(MID( TEXT( CreatedDate - 5/24 ), 12, 2 ))>11, "PM", "AM")

Need Help with Formula Field

Data Management

Aprendizaje relacionado

Más ayuda