Date manipulation

[EvansM]

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

[apathetichell · Accepted 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.

[EvansM · Accepted solution]

@apathetichell How can you do this with string data type? 

[apathetichell · Accepted solution]

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