Date in spreadsheet to plus one day with results as MMDDYYYY

[snadeau456]

Spreadsheet has a Expiration Date column reflecting dates in this format 03/31/2024; need to change this date to a plus one 04012024 with no slashes nor dashes. 

Do not want time included.

[cjaneczko]

You can use the following provided the date coming into the workflow is in a string format. If its already in a date format you can remove the DateTimeParse function.

datetimeformat(datetimeadd(DateTimeParse([Field1],'%m/%d/%Y'),1,'days'),'%m%d%Y')

[snadeau456 · Accepted solution]

Thank you so much, had to tweak as the Field1 date reflected as 2024-03-31;  

datetimeformat(datetimeadd(DateTimeParse([PRVFLAG_EXPRTN_DT],'%y/%m/%d'),1,'days'),'%m%d%Y')