Hello,
I need a help to add a day on the date. Please refer attached doc, also see the example below
The scenario is when [DISCONNECTION_DATE] is null, I want to be populated with [CONNECT_DATE] + 1 day
Data sample
Expected Results
Solved! Go to Solution.
if isnull([disconnection_date]) then datetimeadd([connect_date],1,"days") else [disconnection_date] endif (in formula tool - modifying [disconnection_date])
note - you'll need both fields to be dates to do that.
@apathetichell How can you do this with string data type?
The attached shows you the fastest way to get there - but you should practice with the date/time tool and watch the video on date/time here:
https://community.alteryx.com/t5/Interactive-Lessons/DateTime-Functions/ta-p/98952