Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

If Statement for Day and Time

Hello,

 

I am trying to build a statement for the below by shift , but with no luck. 

 

A: Sunday-Tuesday 6:00 am-6:00 pm, Wednesday 6:00 am-Noon = Green Days

 

B: Wednesday Noon-6:00 pm, Thursday-Saturday 6:00 am-6:00 pm = Yellow Days

 

C shift Sunday-Tuesday 6:00 pm-6:00 am, Wednesday 6:00 pm-12:00 am = Green Nights

 

D shift Wednesday 12:00 am-6:00 am, Thursday- Saturday 6:00 pm-6:00 am = Yellow Nights

 

 

if Date.DayOfWeek([END_DATE_TIME])=<3 and Time.Hour[END_DATE_TIME])>=6 and Time.Hour([END_DATE_TIME])<16 then "Green Day"

 

Your help is much appreciated. 

3 Replies