Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

How can I add 1 day with date diff

Kinetic_analytics
11 - Bolide

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

5 REPLIES 5
JoeS
Alteryx
Alteryx

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
17 - Castor

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

 

Spoiler
binuacs_0-1640267261984.png

 

Kinetic_analytics
11 - Bolide

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

Kinetic_analytics
11 - Bolide

Thank you. Appreciate your help. 

JoeS
Alteryx
Alteryx

@Kinetic_analytics  You're welcome.

 

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

Labels