+ Start a Discussion
YashhYashh 

Want a logic on formula fields.

i have create two custom dates fields like start date and end date
so i have create a check box to chek active status so
i want logic on start date should be less than or equal to today and end date should be greater than equal than today.
help
Best Answer chosen by Yashh
CharuDuttCharuDutt
Hii Yash
Try Below Formula Data Type(Chaeckbox)
IF(AND( Startdatefield <= TODAY() , Enddatefield>= TODAY() ), true, false)

Please Mark It As Best Answer If It Helps 

Thank You!

All Answers

CharuDuttCharuDutt
Hii Yash
Try Below Formula Data Type(Chaeckbox)
IF(AND( Startdatefield <= TODAY() , Enddatefield>= TODAY() ), true, false)

Please Mark It As Best Answer If It Helps 

Thank You!

This was selected as the best answer
Suraj Tripathi 47Suraj Tripathi 47

Hi Yash,

Try this one:

IF(AND(StartDate__c <= TODAY() ,  EndDate__c>= TODAY() ), true, false)

Please mark it as best answer if it helps.

Thank You