Formula that equals today's date plus 1

[Khristian_Evans]

Formula 

Today's date 2/20/2025 

Output 2/21/2025

[binuacs]

@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')

[Khristian_Evans]

yyyymmdd

[Khristian_Evans]

yyyymmdd format 

add a day to the date of when workflow is ran 

so if today (20250220) 

output should be 20250221

[binuacs · Accepted solution]

@Khristian_Evans 

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

[Khristian_Evans]

Null return, can you help with this?

[Yoshiro_Fujimori]

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

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