How to -1 day to date

Question

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 Answer

Hi @JenniferRubino ,

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

hope this helps,

M.