Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop 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
20 - Arcturus

@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