Is your end date in the future? If so, you are going to get a negative result. You may need to flip the order of the dates around.
Try writing a formula with just DATETIME_DIFF() and experimenting with different input dates (both past and future) until you understand how it works. Then nest it inside the IF().
You blank result also doesn’t look blank to me. It looks like a single space character.
Is your end date in the future? If so, you are going to get a negative result. You may need to flip the order of the dates around.
Try writing a formula with just DATETIME_DIFF() and experimenting with different input dates (both past and future) until you understand how it works. Then nest it inside the IF().
You blank result also doesn’t look blank to me. It looks like a single space character.
Thank you, I hadn't considered negative results so I've found the answer now.