How can I add 1 day with date diff

[Kinetic_analytics]

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

[JoeS · Accepted 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

[binuacs · Accepted solution]

@Kinetic_analytics DateTimeDiff(DateTimeNow(),[Task Created Date],"days") + 1

Spoiler

[Kinetic_analytics]

Thank you. Brilliant. Appreciate your support in my learning process, Joe. Have a great day! 

[Kinetic_analytics]

Thank you. Appreciate your help. 

[JoeS]

@Kinetic_analytics  You're welcome.

Nice addition @binuacs keeping today's date as part of the expression 😀