I am trying to get the previous date for a column that already has dates in them. The column is called [resolveddate] and it has random dates beginning on 8/1/22 to present. So if a rep closed work on 8/29/22, how to do get the previous day's date of 8/28/22? The reason I'm doing this, some times reps make visits to clients, but don't close the online paper work up to three days later. I need to use this expression when a rep makes a visit on 8/26 and closed the online paper work on 8/29. I need an expression to change the online paper work close date of 8/29 to change it to 8/26 to match the visit date.
