Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Date differences with null values

Topic Labels: Formulas
Solved
Jump to Solution
2802 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Anabel_Hurtado
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

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')

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

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')

Thank you! That worked!