I am trying to develop a formula to determinate current days until the end of a campaign.
For that i have the following fields
- Start Date
- End Date
- Days from Today to End Date
The code that i am implementing and its not working correctly is.
IF( Now() >= EndDate , 0, EndDate - TODAY())
So basically what i want to accomplish is. If today is equal to the end day of the campaign return 0 else return the remaining days.