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 😀