+ Start a Discussion
anu123anu123 

Day of the created date

Hi all, 

  i want to get the day of the created date in lead object.How to write formula field for this .any one can u please help me.

 

Tahnks in advance

anu.....

SteveMo__cSteveMo__c

Are you looking for something like this?

CASE(MOD( DATEVALUE(CreatedDate) - DATE (2000 ,1, 1) ,7), 0, "Saturday",1,"Sunday",2,"Monday",3,"Tuesday",4,"Wednesday",5,"Thursday",6,"Friday" ,"ERROR")

 

SteveMo__cSteveMo__c

are you all set with this or do you still need help?

SteveMo__cSteveMo__c

anu123 are you all set or do you still need help on this?