You need to sign in to do that
Don't have an account?
bhanu_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 ?
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 ?
Go through with the below link.
https://success.salesforce.com/answers?id=9063A000000iU8pQAE
Thanks,
Amit
All Answers
Go through with the below link.
https://success.salesforce.com/answers?id=9063A000000iU8pQAE
Thanks,
Amit
Hi,
Could you describe exactly what is use case of the above formula?