You need to sign in to do that
Don't have an account?
Myriam Zaidi
Formula For Time Intervals
I am currently trying to create a formula that will include a time interval, meaning I want to identify the accounts that have been active between 2 and 5 years from today. Is that possible? If so, how? (i.e. for the time between today and two years ago, it'd be TODAY()+730, but how do I set it for TODAY()+730 until TODAY()+1825?)
If you create a formula that returns a checkbox, and assuming your date field is called Date__c, then you can write it like this:
If the accounts were active the date must be in past why are we adding days here,
instead
I am assuming 730 and 1825 are days here.
Regards,
Deepak Rathinavelu