This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!
Hello:
This is the formula I have used.
DateTimeDiff([Today],[Task Created Date],'days')
I want to add (+1) day with the date diff. I am getting Null Output. How can I fix it?
Thanks
Solved! Go to Solution.
Sorry, when you say add one day, do you mean work out the difference and then make the number 1 day higher?
If so that would be: DateTimeDiff([Today],[Task Created Date],'days') + 1
Or did you mean that you wanted to add one day onto a date?
If so that would be: DateTimeAdd([Task Created Date],1,"days")
Thanks
Joe
Thank you. Brilliant. Appreciate your support in my learning process, Joe. Have a great day!
Thank you. Appreciate your help.
@Kinetic_analytics You're welcome.
Nice addition @binuacs keeping today's date as part of the expression 😀