function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
avvidyar1.3944465313601482E12avvidyar1.3944465313601482E12 

Workflow rule get not triggered even if work evaluation criteria is met and triggered when Eval criteria is not met

Hi All , 

Below is my workflow rule criteria .
=======================================
AND(
Incoming, ISPICKVAL( Parent.Origin,'CIN-TAC Korean'),
OR(
AND(IF(CASE(
MOD(DATEVALUE(CreatedDate) - DATE(1900, 1, 7), 7),
0, 'Sunday',
1, 'Monday',
2, 'Tuesday',
3, 'Wednesday',
4, 'Thursday',
5, 'Friday',
6, 'Saturday','Error')='Friday',true,false),VALUE(MID(TEXT(CreatedDate),12,2))>=8),
AND(IF(CASE(
MOD(DATEVALUE(CreatedDate) - DATE(1900, 1, 7), 7),
0, 'Sunday',
1, 'Monday',
2, 'Tuesday',
3, 'Wednesday',
4, 'Thursday',
5, 'Friday',
6, 'Saturday','Error')='Saturday',true,false),VALUE(MID(TEXT(CreatedDate),12,2))>=0),
AND(IF(CASE(
MOD(DATEVALUE(CreatedDate) - DATE(1900, 1, 7), 7),
0, 'Sunday',
1, 'Monday',
2, 'Tuesday',
3, 'Wednesday',
4, 'Thursday',
5, 'Friday',
6, 'Saturday','Error')='Sunday',true,false),VALUE(MID(TEXT(CreatedDate),12,2))<8)
)
)

==============================

The expected output is it should work 
From fri 4:00 PM to Sat 8:00 AM GMT+8 (Fri 8:00 AM to Sat 12:00 AM  GMT ) 
From Sat 8:00 AM to Sun 8:00 AM GMT+8 (Sat  12:00 AM to Sun 12:00 AM  GMT) 
From Sun 8:00 AM to Sun 4:00 PM GMT+8 (Sun 12:00 AM to Sun 4:00 PM GMT)

But the the Actual output is 

Friday 4 pm to  Saturday 8 am GMT+8     -- works fine   (GMT 8:00 AM   Fri to 12:00 AM Sat )
Saturday 8 am to  4 pm  GMT+8                -- not work                 (GMT 12:00 AM Sat to 8:00 Am Sat )
Saturday 4pm to Sunday 4 pm  GMT+8    -- works fine  (GMT 8:00 Am Sat  to 8:00 Am Sun )
Moday 8 Am to  Monday 4 pm  GMT+8      -- Should'nt work but working  (GMT 12:00 AM Mon to 8:00 AM Mon  )

Please check where i am doing wrong . 

Thanks, 
Avantika
avvidyar1.3944465313601482E12avvidyar1.3944465313601482E12
Hi All , 

Its really urgent for me please let me know .

Thanks, 
Avantika