Forum Discussion
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.
Anonymous
How is this post different from your existing post?
3 Replies
- amitchandak
Super User
What is the issue you are getting? Can you share your table structure with sample data.
You can also try SWITCH, true
- VasTg
Memorable Member
Anonymous
How is this post different from your existing post?
- AnonymousNot applicable
Hello,
I wanted to start a new thread since the original thread was solved on my original request.
I am getting an error when trying to insert the dayofweek function.