add +1 day to date

hello,

im trying to add + 1 day to below system date so should be 5 September 20. I am not particular on the structure of date so long it adds 1 day to the System Date. Have tried using formula using DateTimeAdd(DateTimeParse([SystemDate],"d-mon-%y"),+1,"days") but it return as Null. Many thanks in advance!

Workflow

Accepted answers

sorry using system date field

DateTimeFormat(DateTimeAdd(DateTimeParse([SystemDate],"%d-%b-%y"),+1,"days"),'%d-%b-%y')

Hi @KLS,

Here is the solution:

DateTimeFormat(DateTimeAdd(DateTimeParse([SystemDate],"%d-%b-%y"),+1,"days"),'%d-%b-%y')

All comments

Hi @KLS ,

You almost got it right.

DateTimeAdd(DateTimeParse([SystemDate],"%d-%b-%y"),+1,"days")

To know more about the parameter, see here: https://help.alteryx.com/current/designer/datetime-functions

Best,

Fernando Vizcaino

Hello @KLS ,

Building on @fmvizcaino , if you want as a string and in the same format

DateTimeFormat(DateTimeAdd(DateTimeParse([f],"%d-%b-%y"),+1,"days"),'%d-%b-%y')

sorry using system date field

DateTimeFormat(DateTimeAdd(DateTimeParse([SystemDate],"%d-%b-%y"),+1,"days"),'%d-%b-%y')

Hi @KLS,

Here is the solution:

DateTimeFormat(DateTimeAdd(DateTimeParse([SystemDate],"%d-%b-%y"),+1,"days"),'%d-%b-%y')

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703