Posts

Showing posts from April 16, 2016

Some Useful Formula Fields

1) Get Week Day CASE(  MOD( DATEVALUE( CreatedDate ) - DATE( 1990, 1, 7 ), 7 ),  0, "Sunday",  1, "Monday",  2, "Tuesday",  3, "Wednesday",  4, "Thursday",  5, "Friday",  "Saturday"  ) 2) Get Month Year Based on PickList Values if(  ispickval(Status__c,'THIS_MONTH'),  (case(Month(Date__c),  1,"JAN",  2,"FEB",  3,"MARCH",  4,"APRIL",  5,"MAY",  6,"JUNE",  7,"JULY",  8,"AUG",  9,"SEP",  10,"OCT",  11,"NOV",  12,"DEC", " "  ) +'-'+ TEXT(year(Date__c))) ,  if(ispickval(Status__c,'NEXT_MONTH'),  (case(Month(Date__c) + 1 ,  1,"JAN",  2,"FEB",  3,"MARCH",  4,"APRIL",  5,"MAY",  6,"JUNE",  7,"JULY",  8,"AUG",  9,"SEP",  10,"OCT",