+1I'm trying to get this formula to calculate the difference between the date 'today' and the date in the field 'End date', then stay blank if it it's more than 10 days but return 'Yes' if it's 10 days or less. I can't get it to return the right values though. Any suggestions for how I can fix this to get the right result?
Best answer by kuovonne
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.
+29Is 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.
+1Is 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.