function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
pavan kumar 177pavan 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.
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" 
)