
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 26, 2019 12:19 PM
I need to find the number of days an agent is active. Currently, I have 3 columns “Start Date”, “End Date”, and “Days Active” and my formula in my Days Active column is:
DATETIME_DIFF({End Date},{Start Date},‘days’)
Some agents are still active and do not have an “end date” and I get an error message in the Days Active Column. How do I enhance my formula to replace null values in the End Date column with today’s date?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 26, 2019 02:58 PM
Welcome to the community, @Anabel_Hurtado! :grinning_face_with_big_eyes: Try this formula:
DATETIME_DIFF(IF({End Date}, {End Date}, TODAY()), {Start Date}, 'days')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 26, 2019 02:58 PM
Welcome to the community, @Anabel_Hurtado! :grinning_face_with_big_eyes: Try this formula:
DATETIME_DIFF(IF({End Date}, {End Date}, TODAY()), {Start Date}, 'days')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 27, 2019 06:52 AM
Thank you! That worked!
