You need to sign in to do that
Don't have an account?
SFDC AVINASH
Formula Correction!
Hi All,
I am trying to impliment the bellow using forumla.
If(TODAY() > (StartDate + (Today -StartDate), 1, 0)
Ex: Today:21/Feb/2015
Start Date:21/Jan/2014
Formula: 21/Feb/2015 > (21/Jan/2014 + ( 1 ) )
Note: In above (Today -StartDate) will give me the Number of Years difference between the two.
How can i write a forumla for this senario?
I am trying to impliment the bellow using forumla.
If(TODAY() > (StartDate + (Today -StartDate), 1, 0)
Ex: Today:21/Feb/2015
Start Date:21/Jan/2014
Formula: 21/Feb/2015 > (21/Jan/2014 + ( 1 ) )
Note: In above (Today -StartDate) will give me the Number of Years difference between the two.
How can i write a forumla for this senario?
CEILING((TODAY() - Startdate__c + 1)/365)
I think this might be your complete formula.
IF( Enddate__c < TODAY(), CEILING((Enddate__c - Startdate__c + 1)/365), IF( Startdate__c <= TODAY(), CEILING((TODAY() - Startdate__c + 1)/365), 1))
All Answers
IF(TODAY() > (StartDate + YEAR(TODAY()) - YEAR(StartDate)), true, false)
CEILING((TODAY() - Startdate__c + 1)/365)
I think this might be your complete formula.
IF( Enddate__c < TODAY(), CEILING((Enddate__c - Startdate__c + 1)/365), IF( Startdate__c <= TODAY(), CEILING((TODAY() - Startdate__c + 1)/365), 1))