You need to sign in to do that
Don't have an account?
avvidyar1.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
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
Its really urgent for me please let me know .
Thanks,
Avantika