Formula that equals today's date plus 1

Formula

Today's date 2/20/2025

Output 2/21/2025

Preparation

Accepted answers

DateTimeFormat(DateTimeAdd(DateTimePArse(ToString([Date]),'%Y%m%d'),1,'day'),'%Y%m%d')

@Khristian_Evans I assume your date is in the format of mm/dd/yyyy

DateTimeFormat(DateTimeAdd(DateTimeParse([Date],'%m/%d/%Y'),1,'day'),'%m/%d/%Y')

yyyymmdd

yyyymmdd format

add a day to the date of when workflow is ran

so if today (20250220)

output should be 20250221

DateTimeFormat(DateTimeAdd(DateTimePArse(ToString([Date]),'%Y%m%d'),1,'day'),'%Y%m%d')

Null return, can you help with this?

You may try changing the data type to String rather than Date.

Date type only accepts strings formated as YYYY-MM-DD.