I need to label each row as Yes or No depending on whether they started an activity Mon thru Fri at 4PM, and anytime on Sat or Sun. My data has start and end time, and if they started the activity after 4pm then it should be tagged as 'Yes', or if they started anytime before 4pm then it's a 'No'. I added Day of Week to my data already, and time as 24 hours. Any help I appreciate. I'm new to Alteryx.
Here is the code I used in SQL related product. Its basically, taking the difference between 4Pm and start time each day. I then have another column that looks at the negative vs positive number and then i flag positive as 'Yes' value.
if(DayOfWeek([d_CreateDate]) in (1, 2, 3, 4, 5),If(DateDiff("mi",Time(16,0,0,0),Time([c_BegTime]))>0,[i_TotalTime],DateDiff("mi",Time(16,0,0,0),Time([c_EndTime]))),[i_TotalTime])
