Skip to Content
0
Former Member
Apr 24, 2014 at 01:32 AM

If Statements

23 Views

Hello,

On the attached report I need assistance:

- I have a formula field that I need to display as either " On call or Daily Assignment " if

The call was recieved on a Saturday or a Sunday or

If call is recieved on a friday after 11pm ( = On call)

All else = Daily assignment

The formula I have tried is

If {@DayOfWeek} = "Friday" Then

{@On Call} = 'Voice On Call' or

If {@DayOfWeek} = "Saturday" Then

{@On Call} = 'Voice On Call' or

If {@DayOfWeek} = "Sunday" Then

{@On Call} = 'Voice On Call'

Else

{@On Call} = 'Daily Assignment'

The field is blank when refreshed and how do I incorporate the time criteria into the statement above?