1

Hi I have start_Date__c which specify project is started. I want formula field to check whether End_Date__c is passed or not. If it is passed then i want to uncheck the checkbox. For example if end date is 30/6/2017 it should be checked meaning project is going on and if date is 1/5/2017, it should get uncheck.

6
  • So, do you want to have a formula checkbox or just a checkbox?
    – kurunve
    Jun 22, 2017 at 9:00
  • 1
    What did you try so far? Jun 22, 2017 at 9:00
  • Formula field should be Check box type and you can improve logic if( start_Date__c <= End_Date__c ,true,false)..true will make check box is checked and false will uncheck.
    – user7601
    Jun 22, 2017 at 9:10
  • Possible duplicate of calculating Date in salesforce
    – Hamza
    Aug 20, 2017 at 8:20
  • What is your ultimate goal? A formula will not cause a trigger to fire. If you just want it to evaluate when the record is being viewed then a formula will work. If you want to fire a process when the time period has passed then a formula field will not do what you want.
    – Eric
    Aug 20, 2017 at 19:20

1 Answer 1

2

Create a formula field datatype as a checkbox.

  1. If you want to validate its endDate with current date then and place this formula in the editor IF(End_Date__c > TODAY() , true, false)
  2. If you want to validate its endDate with start date then and place this formula in the editor IF(End_Date__c > start_Date__c , true, false)

Not the answer you're looking for? Browse other questions tagged .