+ Start a Discussion
bhanu_prakashbhanu_prakash 

time is not working fine

I have used below formula

IF( OR( VALUE( MID( TEXT(CreatedDate + 10), 12, 2 ) ) = 0, VALUE( MID( TEXT( CreatedDate + 10), 12, 2 ) ) = 12 ), "12", TEXT( VALUE( MID( TEXT( CreatedDate + 10), 12, 2 ) ) - IF( VALUE( MID( TEXT( CreatedDate + 10), 12, 2 ) ) < 12, 0, 12 ) ) ) & ":" & MID( TEXT( CreatedDate + 10), 15, 2 ) & " " & IF( VALUE( MID( TEXT( CreatedDate + 10), 12, 2 ) ) < 12, "PM", "AM" )

But actual time is 7:33 PM   and it is showing  9:33 PM , I have tried to modification on above forumla it is showiing same time as 9:33PM  may i know where is the issue ?
 
Best Answer chosen by bhanu_prakash
Amit Singh 1Amit Singh 1
Bhanu,

Go through with the below link.
https://success.salesforce.com/answers?id=9063A000000iU8pQAE
Thanks,
Amit

All Answers

Amit Singh 1Amit Singh 1
Bhanu,

Go through with the below link.
https://success.salesforce.com/answers?id=9063A000000iU8pQAE
Thanks,
Amit
This was selected as the best answer
Arvind KumarArvind Kumar

Hi,

Could you describe exactly what is use case of the above formula?

bhanu_prakashbhanu_prakash
i need to find time stamp without date but final i achevied time stamp but time is actual time is 7:33 PM   and it is showing  9:33 PM. I stucked here