You need to sign in to do that
Don't have an account?
pavan kumar 177
Formula with based on opportunity created time
In our organsation multiple teams are working on sales & in our sfdc organisation we are following PST time zone.
So, we need to know how many opportunities created between 1:30 pm PST to 5:00 PM on same day.
For example:
20/11/17 1:30PM PST 20/11/17 5:00 PM PST
Any possibility to calculate in sfdc
My formula would be:
I took TZoffset is 8/24 because my organisation time zone would be (GMT-08:00) Pacific Standard Time (America/Los_Angeles)
And some opportunities i am facing an issue because Day/light saving and now i am only able to capture time.
So, we need to know how many opportunities created between 1:30 pm PST to 5:00 PM on same day.
For example:
20/11/17 1:30PM PST 20/11/17 5:00 PM PST
Any possibility to calculate in sfdc
My formula would be:
I took TZoffset is 8/24 because my organisation time zone would be (GMT-08:00) Pacific Standard Time (America/Los_Angeles)
And some opportunities i am facing an issue because Day/light saving and now i am only able to capture time.
IF( OR( VALUE( MID( TEXT( CreatedDate - 8/24), 12, 2 ) ) = 0, VALUE( MID( TEXT( CreatedDate - 8/24 ), 12, 2 ) ) = 12 ), "12", TEXT( VALUE( MID( TEXT(CreatedDate - 8/24 ), 12, 2 ) ) - IF( VALUE( MID( TEXT( CreatedDate - 8/24 ), 12, 2 ) ) < 12, 0, 12 ) ) )& ":" & MID( TEXT( CreatedDate - 8/24 ), 15, 2 ) & ":" & MID( TEXT( CreatedDate - 8/24 ), 18, 2 ) & " " & IF( VALUE( MID( TEXT( CreatedDate - 8/24 ), 12, 2 ) ) < 12, "AM", "PM" )