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

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

Hi All,

 

I have a workflow on Opportunity object with evaluation criteria: "When a record is created, or when a record is edited and did not previously meet the rule criteria".

In the rule I check that I am checking one boolean field  (xyz__c) whether it is set as true or not and then I send a notification.

 

Condition1: When I update the record by changing some field value, (when that boolean xyz__c = true) then the workflow does not fire and that is fine as per the conditions.

 

Condition 2: When i update the account Lookup for the Opportunity (still xyz__c = true) then the workflow should not fire but its not the case. This time workflow fires. This is a strange situation only for Account lookup field.

 

Has anyone come across anything as such?