2 respuestas
Salesforce gives the time in GMT format and by adding 5 hours you'll get PST time.
The below formula should work for your requirement with few tweaks.IF( OR( VALUE( MID( TEXT( MYTIMEFIELD + (5/24)), 12, 2 ) ) = 0, VALUE( MID( TEXT( MYTIMEFIELD + (5/24) ), 12, 2 ) ) = 12 ), "12", TEXT( VALUE( MID( TEXT( MYTIMEFIELD + (5/24) ), 12, 2 ) ) - IF( VALUE( MID( TEXT( MYTIMEFIELD + (5/24)), 12, 2 ) ) < 12, 0, 12 ) ) ) & ":" & MID( TEXT( MYTIMEFIELD + (5 /24)), 15, 2 ) & ":" & MID( TEXT( MYTIMEFIELD + (5/24) ), 18, 2 ) & " " & IF( VALUE( MID( TEXT( MYTIMEFIELD + (5/24)), 12, 2 ) ) < 12, "AM", "PM" )Replace : MYTIMEFIELD with your Date & Time field.If it answer your question, mark as solved.Sathish P