If a response time is 2 days and submitted before 1PM is should constitute as a yes.

[justcotto]

I have a script that I have implemented:

if([PAYMENT_GROUP_CODE]='Urgent',if([Response Time]<= '2', 'Yes', 'No'), if([Response Time]<=3, 'Yes', 'No')) AS [SLA Met],

I have another field called 'Approval Time'.  I want to also implement, [Approval Time]<'13:00'.  If a response time is 2 days and submitted before 1PM is should constitute as a yes.  

[crusader_]

Hi,

Try something like below (depend on [Approval Time] field format):

if([PAYMENT_GROUP_CODE]='Urgent',if([Response Time]<= 2 AND [Approval Time]<13/24, 'Yes', 'No'), if([Response Time]<=3, 'Yes', 'No')) AS [SLA Met]

//Andrei