How to -1 day to date

[JenniferRubino]

I am trying to subtract 1 day from the Posted date which is in a format of YYYYMMDD (20210130)

I have tried the following two formulas which both have resulted in Null values.

DateTimeAdd([Posted Date],-1,"days")

DateTimeAdd(DateTimeParse([Posted Date],"%D"),-1,"days")

Any suggestions to fix would be helpful!

[mceleavey · Accepted solution]

Hi @JenniferRubino ,

This is just a formatting issue. You need to convert your string to a date first:

hope this helps,

M.

[Qiu]

@JenniferRubino 
Try to do it with one Formula tool